XL: Lotus 1-2-3 WK4 File Macro Support

ID: Q123265

The information in this article applies to:

Microsoft Excel 97 for Windows
Microsoft Excel for Windows 95, versions 7.0, 7.0a
Microsoft Excel for Windows, versions 5.0, 5.0c

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

For more information about obtaining the Lotus 1-2-3 WK4 File Converter, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q122583
   TITLE     : 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.00 5.00a 5.00c 7.00 7.00a 97 XL97 err msg

Keywords          : kb3rdparty xlloadsave xl123Quattro xlwin 
Version           : WINDOWS:5.0,5.0c,7.0,7.0a
Platform          : WINDOWS

Last Reviewed: January 15, 1999