Migrating macros to newer versions.

**pscornelison** · 11-29-2010, 02:12 PM

When we talk about upgrading macros from one version to the next, what officially does migrate or upgrade mean? Do I have to do an Import of the old personal.xls, or you just OPEN the old macros into the new version and do a SAVE, or does it all happen when you select the MIGRATE option during the install? The new macro code probably looks a little different from the old code, so what modifies it?

I'm getting ready to migrate from 2000 to XP and then to 2003 ultimately to get to 2007. I think I need to do it one version at a time but exactly how does the macro code get upgraded?

Thanks............Steve Cornelison

**JBeaucaire** · 11-29-2010, 02:55 PM

In most ways, newer versions of Excel can run old version macros. New versions simply have more tools available and perhaps could be rewritten more efficiently if you so chose.

There are a few VBA methods that get removed, like the .FileSearch method no longer supported in xl07+. A macro written for 2000 should work in 2007, but you'd discover it didn't the first time you tried and DEBUGging should take you right to the problem code.

**pscornelison** · 11-29-2010, 03:52 PM

Originally Posted by JBeaucaire

In most ways, newer versions of Excel can run old version macros. New versions simply have more tools available and perhaps could be rewritten more efficiently if you so chose.

There are a few VBA methods that get removed, like the .FileSearch method no longer supported in xl07+. A macro written for 2000 should work in 2007, but you'd discover it didn't the first time you tried and DEBUGging should take you right to the problem code.

Thanks for the reply. So I don't need to upgrade/migrate version by version (97 to 200 to XP to 2003 etc)? Is that just a waste of time?

**JBeaucaire** · 11-29-2010, 04:01 PM

Yes it is a waste of time. Excel 2007 can natively open and use prior version workbooks. My wife has xl2007 at work and set it to save files in xl2003 format by default since that's what we use at home.