Application.UserLibraryPath Property (Excel)
Returns the path to the location on the user’s computer where the COM add-ins are installed. Read-only String.
Syntax
expression .UserLibraryPath
expression A variable that represents an Application object.
Example
This example determines where the COM add-ins are installed on the user’s computer and assigns the string to the variable strLibPath.
strLibPath = Application.UserLibraryPath