MOD2000: $(OfficeAddinPath) Macro Does Not Install Files to the Office Addin Folder

View products that this article applies to.

This article was previously published under Q236548

Advanced: Requires expert coding, interoperability, and multiuser skills.

SYMPTOMS

When you try to use the $(OfficeAddinPath) macro from the "Package and Deployment" Wizard to install files into the Office Addins folder, you find that the macro installs the files into the application path.

Back to the top

CAUSE

The $(OfficeAddinPath) macro does not work in Microsoft Office 2000 Developer.

Back to the top

RESOLUTION

To resolve this problem, obtain Microsoft Office 2000 Developer Service Release 1 (SR-1).

To obtain SR-1, click the article number below to view the article in the Microsoft Knowledge Base:

253566 (http://support.microsoft.com/kb/253566/EN-US/ ) MOD2000: How to Obtain and Install Microsoft Office 2000 Developer Service Release 1 (SR-1)

NOTE: The $(OfficeAddinPath) macro does not appear in the Install Location list after you install Office 2000 Developer SR-1. This resolution allows you to install files into the Office/Addins folder, whether the macro appears in the list or does not appear in the list.

To temporarily work around this problem, you can combine the other macros with a portion of the path. For example, if Office is installed in the Program Files\Microsoft Office folder, and you want to place the file in the Office Addins folder, you can set the Install Location to $(ProgramFiles)\Microsoft Office\Office\Addins.

Back to the top

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Office 2000 Developer SR-1.

Back to the top

MORE INFORMATION

Steps to Reproduce Behavior

In Notepad, create a file called "Test.txt" and save it to the root of drive C.
In Access, open the sample database Northwind.mdb.
On the Tools menu, point to Macro, and then click Visual Basic Editor.
In the Visual Basic Editor, if the Package and Deployment Wizard is on the Add-ins menu, skip to step 7.
On the Add-ins menu, click Add-in Manager.
In the Add-in Manager, click VBA Package and Deployment Wizard. Click to select the Loaded/Unloaded check box, and then click OK.
On the Add-ins menu, click Package and Deployment Wizard.
In the "Package and Deployment" Wizard, click Package.
Click Next on each of the next few screen and accept the defaults until you see the screen named Package and Deployment Wizard - Included Files.
Click Add , and then in the Add File dialog box, add the Test.txt file that you created in step 1.
Click Next three times and accept the defaults until you see the screen named Package and Deployment Wizard - Install Locations. Note that the installation location for Test.txt is $(AppPath).
For the Test.txt file, click to select Install Location, and then click $(OfficeAddinPath) in the Install Location list.
Click Next on each screen and accept the defaults until you see the screen named Package and Deployment Wizard - Finished!.
Click Finish to create the package.
Run Setup for the package and accept all the defaults.
Open Windows Explorer and browse to the following location:
C:\Program Files\Microsoft Office\Office\Addins
Note that the Test.txt file is not there. It is in the same folder where you installed the application.