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

• Microsoft Office 2000 Developer

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

You can work around this problem by combining 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 this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce Behavior

1. In Notepad, create a file called "Test.txt" and save it to the root of drive C.



2. In Access, open the sample database Northwind.mdb.



3. On the Tools menu, point to Macro, and then click Visual Basic Editor.



4. In the Visual Basic Editor, if the Package and Deployment Wizard is on the Add-ins menu, skip to step 7.



5. On the Add-ins menu, click Add-in Manager.



6. In the Add-in Manager, click VBA Package and Deployment Wizard. Click to select the Loaded/Unloaded check box, and then click OK.



7. On the Add-ins menu, click Package and Deployment Wizard.



8. In the "Package and Deployment" Wizard, click Package.



9. 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.



10. Click Add , and then in the Add File dialog box, add the Test.txt file that you created in step 1.



11. 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).



12. For the Test.txt file, click to select Install Location, and then click $(OfficeAddinPath) in the Install Location list.



13. Click Next on each screen and accept the defaults until you see the screen named Package and Deployment Wizard - Finished!.



14. Click Finish to create the package.



15. Run Setup for the package and accept all the defaults.



16. 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.

Additional query words: pra

Keywords : kbdta modWFDesigner
Version : :
Platform : WINDOWS
Issue type : kbbug