Microsoft KB Archive/134681

= "Cannot Find Macro" Using Microsoft Excel Add-in =

Article ID: 134681

Article Last Modified on 8/15/2005

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0c

-



This article was previously published under Q134681



5.00 5.00c 7.00 WINDOWS kbsetup





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 '' \Library\ '!

where is the directory where you installed Microsoft Excel.

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

However, when you use an add-in file that references a macro where the path to the macro contains an apostrophe character, you may receive an error message as described above.

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 is the directory to which you installed Microsoft Excel).

Microsoft Excel Versions 5.0 and 7.0

Report Manager

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

View Manager

Cannot find macro '' \Library\VIEWS.XLA'!STUB'

Microsoft Excel Version 7.0 Only
AccessLinks Add-In

Access Form:

Cannot find macro '' \Library\Acclink.xla'!DoFormCommandStub'

Access Report:

Cannot find macro '' \Library\Acclink.xla'!DoReportCommandStub'

Convert To Access:

Cannot find macro '' \Library\Acclink.xla'!DoConvertCommandStub'

Template Wizard with Data Tracking

Cannot find macro '' \Library\Wztemplt.xla'!StartWizardStub'

MS Query Add-in

Cannot find macro '' \Library\Xlquery.xla.xla'!doGetData'

Additional query words: 5.00c XL

Keywords: KB134681

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.