Macros in 2003 VS 2007

[Rick Catala]

Do macros created in Excel 2003 work in Excel 2007?

 

[Smitty]

Welcome to the Board!

In a word, Yes.

But not necessarily the other way around.

If you have a specific concern, feel free to post it.

 

[Greg Truby]

Like Smitty said, it's a pretty good port. The main stuff that gets queered up is if you had menu customizations or created custom toolbars using code. That will still work, but due to the new interface, it all gets dumped in a custom "Add-Ins" tab.

AFAIK, they only took out one object - the filesearch object. I can't think of any other code that would automatically raise an error. But if you use code to create charts, plan on needing to tweak that code.

 

[Rick Catala]

Welcome to the Board!

In a word, Yes.

But not necessarily the other way around.

If you have a specific concern, feel free to post it.

Smitty, Thanks for your reply. Office 2007 will be installed in March and if I encounter any problems with macros I will probably be asking for your help.

Rick