XL: "Cannot Find Macro" Using Microsoft Excel Add-in

The information in this article applies to:

• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

In Microsoft Excel, when you use an add-in, such as Report Manager or View Manager, you may receive the following error message

   Cannot find macro ''<path>\Library\<addin>'!<macro>

Note that in Microsoft Excel, you use the Report Manager by clicking Print Report on the File menu. You use the View manager by clicking View Manager on the View menu.

For more information about specific error messages that you may receive when you use an add-in, see the "More Information" section below.

CAUSE

This problem occurs when you install Microsoft Excel to a directory that contains an apostrophe character ('). This problem occurs because the apostrophe character is reserved in Microsoft Excel to indicate the end of the filename in a link.

When you create a link to a file that is located in a directory that contains an apostrophe character, Microsoft Excel automatically adds an additional apostrophe to the reference. For example, if you create a link to the file Book1.xls located in the directory c:\Excel's, the link is created as in the following example:

   ='c:\Excel''s\[BOOK1.XLS]Sheet1'!$A$1

For example, if you install Microsoft Excel to a directory that contains an apostrophe character, such as c:\Excel's, you may receive an error message when you use an add-in located in a subdirectory of the Microsoft Excel directory, such as Views.xla or Reports.xla.

Note that when the path to the add-in contains an apostrophe character, if you load the add-in file using the Add-Ins dialog box, you do not receive an error message when you use the add-in. However, when you close and then start Microsoft Excel again, you receive the error message described above when you use the add-in.

RESOLUTION

To avoid this problem, install Microsoft Excel to a directory that does not contain an apostrophe character.

As a temporary workaround, to avoid this problem, you can use the Add-Ins dialog box to load the add-in again. However, this workaround only works until you close Microsoft Excel. The next time you start Microsoft Excel and use the add-in, the problem occurs again.

MORE INFORMATION

The following is a description of the different error messages that appear when you use a Microsoft Excel add-in after installing Microsoft Excel to a directory that contains an apostrophe character (where <path> is the directory to which you installed Microsoft Excel).

Microsoft Excel Versions 5.0 and 7.0

   Report Manager
   --------------

   Cannot find macro ''<path>\Library\REPORTS.XLA'!mcp01.PrintReport'

   View Manager
   ------------

   Cannot find macro ''<path>\Library\VIEWS.XLA'!STUB'

Microsoft Excel Version 7.0 Only

   AccessLinks Add-In
   ------------------

   Access Form:

   Cannot find macro ''<path>\Library\Acclink.xla'!DoFormCommandStub'

   Access Report:

   Cannot find macro ''<path>\Library\Acclink.xla'!DoReportCommandStub'

   Convert To Access:

   Cannot find macro ''<path>\Library\Acclink.xla'!DoConvertCommandStub'

   Template Wizard with Data Tracking
   ----------------------------------

   Cannot find macro ''<path>\Library\Wztemplt.xla'!StartWizardStub'

   MS Query Add-in
   ---------------

   Cannot find macro ''<path>\Library\Xlquery.xla.xla'!doGetData'