Microsoft KB Archive/70239

{| = COMPARE.XLA Fails with Filenames that Begin with a Number =
 * width="100%"|

Last reviewed: November 3, 1994

Article ID: Q70239 The information in this article applies to:
 * Microsoft Excel for Windows, version 3.0

SUMMARY
The add-in macro COMPARE.XLA will fail if you attempt to compare a file with a name that begins with a number. You will receive the message &quot;Macro Error at cell: COMPARE.XLA!B52.&quot;

MORE INFORMATION
Renaming the file so that the name begins with a letter or &quot;_&quot; character allows the add-in to work.

Steps to Reproduce Problem

 * 1) On Sheet1, enter &quot;test&quot; (without the quotation marks) in cell A1.
 * 2) On Sheet2, enter &quot;test&quot; in cell A1.
 * 3) Save Sheet2 as 1TEST.XLS.
 * 4) Choose Compare from the Formula menu.
 * 5) Select Sheet1 and choose OK.
 * 6) You will receive the error listed above.

STATUS
Microsoft is researching this problem and will post new information here as it becomes available.