Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
RodolfoDallas
 
Posts: n/a
Default how do I run excel 4.0 macros on excel 2000

Have an old EXCEL file with macros written many years ago (perhaps Excel
4.0). Pretty complex macros. Excel 97 opens the file and runs the macros with
no problem. When trying to open the file on a computer with Excel 2000, the
file opens fine, but no acknowledgement of any macros is reported, and the
macros don't run. They do not appear on the MACROS list in either version of
Excel. I have changed the macro security to medium and low: still no
acknowledgement of any macros on the file. I did not write the macros, but I
see some formulas that look like: '{GOTO}A121~/WGRM{GOTO}AAK~3000 which I
had never seen before. When the file is opened in Excel 97, the macro is
activated and a Menu comes up with a list of letters (A to G) of the
different functions (macros, I assume) that can be invoked and that can be
activated by the Ctrl+letter sequence. Am I missing something somewhere?
Shouldn't the macro simply run?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Middleton
 
Posts: n/a
Default how do I run excel 4.0 macros on excel 2000

RodolfoDallas -

Looks like keystroke-based Lotus 1-2-3 macros. According to Excel's Help:

Microsoft Excel 2000 and later versions do not run Lotus 1-2-3 macros.

- Mike
www.mikemiddleton.com

"RodolfoDallas" wrote in message
...
Have an old EXCEL file with macros written many years ago (perhaps Excel
4.0). Pretty complex macros. Excel 97 opens the file and runs the macros
with
no problem. When trying to open the file on a computer with Excel 2000,
the
file opens fine, but no acknowledgement of any macros is reported, and the
macros don't run. They do not appear on the MACROS list in either version
of
Excel. I have changed the macro security to medium and low: still no
acknowledgement of any macros on the file. I did not write the macros, but
I
see some formulas that look like: '{GOTO}A121~/WGRM{GOTO}AAK~3000 which I
had never seen before. When the file is opened in Excel 97, the macro is
activated and a Menu comes up with a list of letters (A to G) of the
different functions (macros, I assume) that can be invoked and that can be
activated by the Ctrl+letter sequence. Am I missing something somewhere?
Shouldn't the macro simply run?



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
Send to from excel 2003 after upgrade from Office 2000 Anthony Excel Discussion (Misc queries) 2 December 1st 05 08:59 PM
Migrating from Excel 2000 to Excel 2003 Rene H Excel Discussion (Misc queries) 1 November 24th 05 03:48 PM
Excel XP 2002 Vs. Excel 2000 Samantha Excel Discussion (Misc queries) 0 April 18th 05 03:54 PM
other systems detecting excel 4.0 if excel 2000 is installed Tristan_Flynn Setting up and Configuration of Excel 0 January 18th 05 06:55 PM
Statistical Excel Function Question within Excel 2000... Drew H Excel Worksheet Functions 3 October 31st 04 06:55 PM


All times are GMT +1. The time now is 12:05 AM.

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"