Hi
Is there any difference between Excel2000 vba and Excel97 vba.
Basically I developed a program in 2000 and transferred the code over to 97 and the application in 97 is now working.
Printable View
Hi
Is there any difference between Excel2000 vba and Excel97 vba.
Basically I developed a program in 2000 and transferred the code over to 97 and the application in 97 is now working.
you'll notice some differences...
1. DO NOT USE VARIANTS!
2. when referring to application specific objects, it's a good idea to code from the beginning level of that object (i.e. Excel.Worksheet.Activate)
At work we switched over.. I had lots of automated spreadsheets..
Nothing went awry..
No worries
Seahag