VBA created in excel2003 doesn't work in 2000

[Sue Robson]

Hi
I am currently creating a diary using excel 2003 and VBA code. However my
co-workers and other users still only have excel 2000 and unfortunately
various code errors occur rendering the project unusable. Is there a list of
VBA conflicts etc which I can use to trouble shoot this so that I can create
a seperate version for my 2000 users?

This is my first time on a news group - I hope someone can help

Thanks so much

Sue

--
Sue Robson
Consultant Sport Science Director / Head Physiologist
USSA
Email: (e-mail address removed)
Tel/Fax: Australia (61) 2 66245326
Mail: 43 Napier St
Goonellabah, NSW 2480
AUSTRALIA

 

[Guest]

There are a number of differences. My best guess (the error that is posted
most often) is that it is crashing on a sort... If you have a sort in your
macro look for this

,DataOption1:=xlSortNormal

and delete it. It is (most likely) not necessary. there are other
differences such as the code for pivot tables, so if the error is not coming
from a sort then post your code...

 

[Dave Peterson]

I bet Jim guessed right...

But if he didn't, you should post a snippet of the code and indicate the
offending line.

And if you're importing a text file, remove the TrailingMinusNumbers stuff.

(Jim took the good guess!)