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

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

Additional query words: 4.00a 123 converter conversion

Keywords :
Version : 4.00 5.00
Platform : WINDOWS
Issue type :


Last Reviewed: July 29, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.