Worksheet Name in 4.0 Macro File Contains Filename Extension

• 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.

REFERENCES

For more information about What Happens When I Open My Old Microsoft Excel Files In Version 5.0, choose the Search button in Help and type:

    Microsoft Excel 4.0