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.

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