Lotus 1-2-3 WK4 File Macro Support
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