macros dont work
 

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

macros dont work
 

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

macros dont work
 

HELLO ANYONE THERE?

macros dont work
 

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

macros dont work
 

this stinks

macros dont work
 

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?

macros dont work
 

All come up with a run-time error 100

Thanks

macros dont work
 

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/

macros dont work
 

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