Lotus 1-2-3 WK4 File Macro Support

This article was previously published under Q123265
This article has been archived. It is offered "as is" and will no longer be updated.
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.
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
5.00a 5.00c 7.00a 97 XL97 err msg XL

Article ID: 123265 - Last Review: 10/26/2013 02:44:00 - Revision: 3.0

Microsoft Excel 97 Standard Edition, Microsoft Excel 95 Standard Edition, Microsoft Excel 5.0 Standard Edition

  • kbnosurvey kbarchive kb3rdparty KB123265