Error Running Lotus 1-2-3 Macros with 3-D ReferencesLast reviewed: September 12, 1996Article ID: Q120733 |
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.
CAUSEThe 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. Multi-ply (3-D) Lotus workbooks are a feature of Lotus 1-2-3 versions 3.0 and later; therefore, the macro interpreter is not compatible with, and will not interpret, sheet addresses with 3-D references.
WORKAROUNDTo work around this problem, open the macro in Microsoft Excel and remove the sheet reference. For example, edit the following macro
/Rva:a6..a:d6~a:a9~to read:
/Rva6..d6~a9~The macro should now run correctly.
REFERENCESFor more information about running Lotus 1-2-3 macros, choose the Search button in Help and type:
Lotus 1-2-3 |
KBCategory: kb3rdparty
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |