Programming Excel with VBA and .NET

Install Templates and Add-ins

Templates and add-ins must be installed at specific locations on the user’s machine in order to appear automatically in Excel. Where you install the file determines whether it is available only to the current user or to all users. Table 6-4 lists the various locations used by Excel for templates and add-ins.

Table 6-4. Install locations for workbooks, templates, and add-ins

Name	Location	Comments
Startup	%ProgramFiles%\Microsoft Office\OFFICE11\XLSTART	Excel loads workbooks in this folder on startup. Excel includes templates in this folder on the General page of the Templates dialog.
Alt startup	Configured by the user on the General page of the Options dialog.	Workbooks and templates copied to this folder are loaded automatically on start-up in the same way as \XLSTART.
Network templates	If the user specified a shared network folder in Alt startup before, Excel loads templates from that location.	If set, this folder is returned as the Application object’s NetworkTemplatesPath property.
Add-ins library	%ProgramFiles%\Microsoft Office\OFFICE11\Library	Add-ins copied to this folder appear in the Available Add-Ins list of the Add-Ins dialog.
Spreadsheet solutions library	%ProgramFiles%\Microsoft Office\Templates\1033	Displays templates in the Spreadsheet Solutions page of the Templates dialog.
User add-ins	%UserProfile%\Application Data\Microsoft\AddIns	This is the default location when the user saves a file as an add-in. Add-ins ...