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

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

Best wishes Harald

"meagain" skrev i melding
...
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

HELLO ANYONE THERE?

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.



--
Message posted from http://www.ExcelForum.com

this stinks

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




"meagain" wrote in message
...
HELLO ANYONE THERE?

All come up with a run-time error 100

Thanks

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.

--
Regards,
Tom Ogilvy

"kkknie " wrote in message
...
With each new version, a lot of new functionallity gets added to Excel
VBA. If you took advantage of this in a new version and then try to
run it in an old version, you're out of luck. You will either need to
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 great
in 2002 VBA, but hangs in 2000 VBA.

K


---
Message posted from http://www.ExcelForum.com/

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.

--
Regards,
Tom Ogilvy


"meagain" wrote in message
...
All come up with a run-time error 1004

Thanks