Article ID: 236548
Article Last Modified on 9/3/2002
APPLIES TO
- Microsoft Office 2000 Developer Edition
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.
CAUSE
The $(OfficeAddinPath) macro does not work in Microsoft Office 2000 Developer.
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 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.
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.
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:
Note that the Test.txt file is not there. It is in the same folder where you installed the application.
C:\Program Files\Microsoft Office\Office\Addins
Additional query words: pra OfficeAddinPath
Keywords: kbbug kbpending kbworkflowdesigner KB236548
