"Cannot Find Macro" Using Microsoft Excel Add-in (134681)
The information in this article applies to:
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 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 ''<path>\Library\<addin>'!<macro>
where <path> 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.
| Modification Type: | Minor | Last Reviewed: | 8/15/2005 |
|---|
| Keywords: | KB134681 |
|---|
|