The information in this article applies to:
SYMPTOMSWhen you run a Lotus 1-2-3 macro in Microsoft Excel, you may receive a macro error if the macro contains a reference to another worksheet ply. A Lotus 1-2-3 macro written in Lotus version 3.x and later may have commands that refer to other worksheet plies. CAUSE
The Microsoft Excel macro interpreter is compatible only with macros
written in Lotus 1-2-3 version 2.01 or earlier. Because version 2.01 of
Lotus 1-2-3 does not recognize sheet names, the macro interpreter does not
recognize these additional characters within a reference. WORKAROUNDTo work around this problem, open the macro in Microsoft Excel and remove the sheet reference. For example, edit the following macro
to read:
The macro should now run correctly.
REFERENCES
For more information about running Lotus 1-2-3 macros, choose the
Search button in Help and type:
Additional query words: 4.00a 123 converter conversion
Keywords : |
Last Reviewed: July 29, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |