translate lotus 1-2-3 macro into excel macro using excel 2000

[Guest]

I am trying to use my lotus 1-2-3 file with a macro. I am trying to use excel
97 or excel 2000 to run the macro. In 97, I can open the file and run the
macro, however; when I run the visual basic editor to look at the macro,
nothing is there. I am trying to be able to actually run this macro using my
excel 2000. Is there a way for me to import this old lotus macro into the VB
editor and get it to work? What do I need to do? Please help!

 

[Stephen Bullen]

Hi,

I am trying to use my lotus 1-2-3 file with a macro. I am trying to use excel
97 or excel 2000 to run the macro. In 97, I can open the file and run the
macro, however; when I run the visual basic editor to look at the macro,
nothing is there. I am trying to be able to actually run this macro using my
excel 2000. Is there a way for me to import this old lotus macro into the VB
editor and get it to work? What do I need to do? Please help!

Unfortunately, the only way to do it is to rewrite the macro in VBA. FWIW, a
simple translation is rarely the way to go, but instead it's best to recreate
the macro's functionality.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk