Excel 97 vs. Excel 2003

[Syed Zeeshan Haider]

Hello Experts,
A friend of mine, who is not a fond of programming, has given me a certain
task for research purposes. I have to accomplish this task in Excel with the
help of its VBA.
I have Excel 97 Pro on Win 98 while my friend has Excel 2003 Pro on WinXP
2003 Pro SP1.
I have developed some huge and complex code on my PC.
When I took this code to my friends PC, and ran it, first of all it gave me
an error on the last part of following line:

For Each cCell in [A3:A2000]

The error said "Object required".

When I replaced [A3:A2000] with Range("A3:A2000"), the code began to work.

How come a piece of code which works in Excel 97 Pro does not work in Excel
2003 Pro?
Are there any other conflicts like this one?
Where can I find them? URL etc.?

Thank you,

 

[alainB]

Hi,

I am no expert but I am using Excel 97.

Just to let you know, if you don't know it already, that there is
"service pack" (it is not named service pack, but the files are SR-
and SR-2) available at Microsoft for excel 97. You need to downloa
both of them, install SR-1 and then install SR-2.

No idea if it will help you.

Alai

 

[Howard Kaikow]

Code that works in earlier versions of Word or Excel or ... does not
necessarily work in later versions due to changes in the way things work, or
in new bugs in the later versions, or in bugs being exposed in code one
thought was correct.

The message you received implies that cCell is not an object or Cell data
type or Excel 97 wants the more appropriate Range("A3:A2000").

 

[Syed Zeeshan Haider]

Just to let you know, if you don't know it already, that there is 2
"service pack" (it is not named service pack, but the files are SR-1
and SR-2) available at Microsoft for excel 97. You need to download
both of them, install SR-1 and then install SR-2.

Thanks!
Now I am gonna search these things on MS site

Thanks again!