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.
Application.UserLibraryPath
Application.UserLibraryPath
The Application.UserLibraryPath property returns to the location on the user’s computer where the COM add-ins are installed.
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