Excel VBA: Getting Add-Ins Folder Path

This Excel VBA macro shows a message box with the add-ins folder path.

Macro Example

Sub GetAddInsFolderPath()

 MsgBox Application.UserLibraryPath

End Sub

Description

Application

  Application...

The Application property returns the Application object.

Excel-Global-Application

Application.UserLibraryPath

  Application.UserLibraryPath

The Application.UserLibraryPath property returns to the location on the user’s computer where the COM add-ins are installed.

Excel-Application-UserLibraryPath

The code: Application.UserLibraryPath is set to the parameter of a MsgBox function.
So, a message box displays the Add-Ins folder path.

Sub GetAddInsFolderPath()

 MsgBox Application.UserLibraryPath

End Sub

Properties

http://www.relief.jp/itnote/archives/018000.php

Apply to

  • Excel 2016 for Windows
  • Excel 2013
  • Excel 2010
  • Excel 2007