VBA created in excel2003 doesn't work in 2000
 

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:
Tel/Fax: Australia (61) 2 66245326
Mail: 43 Napier St
Goonellabah, NSW 2480
AUSTRALIA

VBA created in excel2003 doesn't work in 2000
 

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...
--
HTH...

Jim Thomlinson


"Sue Robson" wrote:

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:
Tel/Fax: Australia (61) 2 66245326
Mail: 43 Napier St
Goonellabah, NSW 2480
AUSTRALIA

VBA created in excel2003 doesn't work in 2000
 

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!)

Sue Robson wrote:

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:
Tel/Fax: Australia (61) 2 66245326
Mail: 43 Napier St
Goonellabah, NSW 2480
AUSTRALIA

--

Dave Peterson