Microsoft KB Archive/118976

{|
 * width="100%"|

Worksheet Name in 4.0 Macro File Contains Filename Extension

 * }

-

The information in this article applies to:


 * Microsoft Excel for the Macintosh, version 5.0

-

SYMPTOMS
In Microsoft Excel 5.0, when you open a Microsoft Excel version 4.0 macro file, the macro sheet name includes the filename extension. This behavior may cause an error if you run a macro that expects the macro sheet name to be the name of the macro file without the filename extension. This behavior may also cause an error value to be returned in a workbook that contains a reference to the macro sheet.

CAUSE
This behavior occurs because, when you open a Microsoft Excel version 4.0 macro file in Microsoft Excel version 5.0, the file is opened as a workbook that contains a single macro sheet. In Microsoft Excel for Windows, the macro sheet name is the same as the workbook name without the filename extension. For example, if the macro file name is MACRO1.XLM, the macro sheet name is MACRO1. In Microsoft Excel for the Macintosh, the macro sheet name is the same name as the workbook name, including the file extension. For example, if the macro file name is MACRO1.XLM, the macro sheet name is MACRO1.XLM.

This is only a problem when you share version 4.0 macro files between Microsoft Excel for Windows and Microsoft Excel for the Macintosh, because the macro sheet name is different in each version.

STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.