Upgrade Nightmare

[Elsie]

Hello again

I have written an application that uses many VBA macros which were working perfectly under Windows 95 but now we have been upgraded to 2000, don't work at all! Can anyone suggest a solution?

Many thanks.

Elsie

 

[Jack in the UK]

Hi

Excel version do differ and thier VBA also has changes too, so some vba LINES can fault in different versions and even the spacing can change and the delivery of codes.

Normal if you go down this issue is compounded, can i suggest posting one code and see if we can help you fix it, some gurus on this site might just edit a bit and problem solved.
If needs be solve one post the next until al solved

HTH

Post your first code !

 

[stevebausch]

Probably not the operating system, unless the code is opening/closing files, and the namings are causing trouble. Usually filenaming is a backwards compatibility issue.

If the files are being pulled across a network, what is the OS of the network server?

Chances are it's the version of Excel. Excel's version conflicts usually halt the program; it doesn't continue on with flawed behavior.

Have you opened the offending workbooks and re-compiled them in the new version? What sort of compile errors do you see?

I have had issues toggling back and forth from the Excel 97 at work, and my home computer's Excel 2002. Usually Excel 97 does the complaining.