VBA Macros in Excel 2007

The big questions: Will the macros developed in earlier versions of Excel (1997-2003) work in Excel 2007?
The answer:  Yes, 99.99% of them.

Up to Excel 2007 you didn't need to install the Visual Basic Editor if you wanted to develop macros (VBA procedures). In Excel 2007 you must specify that VBA be installed when you install Excel from the Office CD. You know it is installed when you see the item "Developer" in the menu bar.

All macros and VBA procedures developed in Excel 1997 and up will work in Excel 2007 except for a few minor changes:

- a function used only by advanced users "FileSearch" doesn't exist anymore. It can be easily replaced by "Dir" that runs in Excel 2007 and in earlier versions of Excel.

- Advanced users who import external data with or without SQL might want to add these two lines of code at the end of the refresh process:
ActiveSheet.ListObjects("YourQueryName").Unlink
ActiveSheet.ListObjects("YourQueryName").Unlist

- Use the macro recorder to discover the new ways to cells' background and font colors and of sorting data.

Nothing else has changed in Excel 2007 as far as VBA and macros are concerned.

The macro recorder and the Visual Basic Editor are the same...very friendly.

Back to the top of the page