Error Running Lotus 1-2-3 Macros with 3-D References

Last reviewed: September 12, 1996
Article ID: Q120733
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


KBCategory: kb3rdparty
KBSubcategory:

Additional reference words: 5.00 4.00 4.00a 123 converter conversion



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 12, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.