macros dont work

M

meagain

I have a file that has macros that were created and work in the newest version of excel, but if I open the file in an older version of excel, on another computer, they dont work. Is there a known problem, or a fix for this

Thanks
 
H

Harald Staff

There are 25238 flavors of "dont work" in a Windows environment. Which one
are you encountering ?

Best wishes Harald

meagain said:
I have a file that has macros that were created and work in the newest
Click to expand...
version of excel, but if I open the file in an older version of excel, on
another computer, they dont work. Is there a known problem, or a fix for
this?
 
K

kkknie

With each new version, a lot of new functionallity gets added to Exce
VBA. If you took advantage of this in a new version and then try t
run it in an old version, you're out of luck. You will either need t
recode for the old version or require them to run in the new version.

One example I struggle with is Format(Now,"MM/DD/YY") which works grea
in 2002 VBA, but hangs in 2000 VBA.
 
C

Chip Pearson

You might want to provide a few more details, rather than simply
saying your macros "don't work". What does "don't work" mean? Do
the macros not execute at all? Do they cause run time errors?
Compiler errors? Do they return incorrect results?

You need to be much more specific in asking your question.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
T

Tom Ogilvy

xl2000 US English, Windows 2K

? Format(Now,"MM/DD/YY")
06/03/04

I have never experienced a problem with that in xl2000 or xl97.

The problem might be a bad reference.
 
T

Tom Ogilvy

Did you build a large portion of your macros with the macro recorder? If
so, then the code will use the "new" arguments which will cause problems in
older versions.
 
Top