Code Snippets

List of Add-ins installed

This lists all the Excel add-ins that are installed and the folders they are saved in.

This lists all the Excel add-ins that are installed based on the registry.

Remove an Entry from Registry

Application.LibraryPath

Returns the directory containing the built-in Excel add-ins.
Options > VBA Code > Folder Paths

Application.UserLibraryPath

Returns the directory to the location on the users computer where the COM add-ins are installed. Read Only string
Options > VBA Code > Folder Paths

Important

Do not use the "Auto_Open" event as it is only available for backwards compatibility.