Error Running Lotus 1-2-3 Macros with 3-D References |
The information in this article applies to:
- Microsoft Excel for Windows, versions 4.0, 5.0
SYMPTOMS
When 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.
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.
WORKAROUND
To 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.
REFERENCES
For more information about running Lotus 1-2-3 macros, choose the Search button in Help and type:
Lotus 1-2-3
Additional query words: 4.00a 123 converter conversion
Keywords :
Version : 4.00 5.00
Platform : WINDOWS
Issue type :
Technology : kbvcSearch
Last Reviewed: July 29, 1999 |
