Lotus 1-2-3 WK4 File Macro Support (123265)


The information in this article applies to:

  • Microsoft Excel 97 for Windows
  • Microsoft Excel for Windows 95
  • Microsoft Excel for Windows 5.0
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

Modification Type:MajorLast Reviewed:8/24/2006
Keywords:kb3rdparty KB123265
©2004 Microsoft Corporation. All rights reserved.