Upgrading from Excel 2000 to 2003  
Author Message
JordanL





PostPosted: Visual Basic for Applications (VBA), Upgrading from Excel 2000 to 2003 Top

Our office is upgrading from 2000 to 2003, and a lot of our old VBA code is starting to fail. I'm working my way through and finding and fixing all the errors... but I'm wondering if anyone knows if there's a tool for converting code to the newer VBA version, or if there's a definitive list somewhere of the code/syntax changes that have been made between the versions


Microsoft ISV Community Center Forums3  
 
 
Jon Peltier





PostPosted: Visual Basic for Applications (VBA), Upgrading from Excel 2000 to 2003 Top

I know of no such tool to convert VBA.

You should be able to find references on Microsoft's site that describe changes to VBA. Keep in mind that you'll need to see what's new in 2002, then in 2003, for your upgrade. Try a search like this:

http://www.google.com/search hl=en&lr=&q=microsoft+office+vba+what%27s+new+2002+2003&btnG=Search