Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default translate lotus 1-2-3 macro into excel macro using excel 2000

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!
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 205
Default translate lotus 1-2-3 macro into excel macro using excel 2000

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lotus macro i need to convert to Excel Sammy Excel Discussion (Misc queries) 4 April 28th 10 09:31 PM
HOW DO I RUN A LOTUS MACRO IN EXCEL GM Excel Discussion (Misc queries) 0 November 14th 06 08:37 PM
Translate Excel 2000 file from German into English energytechgroup Excel Discussion (Misc queries) 3 October 25th 06 10:51 AM
how do I convert a lotus macro into excel 2000 krutledge0209 Excel Programming 0 November 2nd 04 02:59 AM
Macro Excel Lotus Notes V5 <= Oulook 2000 Alain V. Excel Programming 1 February 27th 04 10:30 AM


All times are GMT +1. The time now is 10:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"