Article ID: 123265
Article Last Modified on 8/24/2006
APPLIES TO
- Microsoft Excel 97 Standard Edition
- Microsoft Excel 95 Standard Edition
- Microsoft Excel 5.0 Standard Edition
This article was previously published under Q123265
SUMMARY
In Microsoft Excel, the following restrictions apply to running macros contained in a Lotus 1-2-3 WK4 file:
- The commands in the macro must be backward compatible to Lotus 1-2-3 Release 2 (note that Release 2 lacks many of the macro commands available in Release 4). -and-
- When you run the macro, the worksheet that contains the macro code must be active.
NOTE: This restriction means that if you have a separate worksheet that contains the macro code, you cannot use those macros with data that is contained on a different worksheet.
You will receive a macro error when you run a macro contained in a Lotus 1-2-3 WK4 file in Microsoft Excel if either of the above conditions is not true.
MORE INFORMATION
Microsoft Excel versions 7.0 and 97 can open Lotus 1-2-3 WK4 files without the need for an additional converter.
To open Lotus 1-2-3 WK4 files in Microsoft Excel version 5.x, you must obtain the Lotus 1-2-3 WK4 File Converter. The Lotus 1-2-3 WK4 File Converter is available in application note WE1130 "Lotus 1-2-3 WK4 File Converter."
Lotus 1-2-3 is manufactured by Lotus Corporation, a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.
REFERENCES
Lotus 1-2-3 WK4 File Converter README.TXT
For more information about the Macro Interpreter For Lotus 1-2-3 Users, choose the Search button in Help and type:
Lotus 1-2-3, macro conversion
Additional query words: 5.00a 5.00c 7.00a 97 XL97 err msg XL
Keywords: kb3rdparty KB123265