VBA Macros in Excel
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. See how to install Visual Basic for Application for Excel 2007.
In Excel 2010 this problem has been corrected and you do not need to install anything extra to work with macros. YOu might have to make the "Developer" ribbon visible by right clicking on the "Home" item of the menu bar and then selecting "Customize the ribbon..." and making sure that the "Developer" ribbon is checked.
In Excel 2007 and 2010 you save your spreadsheets that do not contain macros in .xlsx format and those with macros in .xlsm format. You can also select to save your spreadsheets in .xls format so that people who have not migrated to Excel 2007 or 2010 can open and use them.
All macros and VBA procedures developed in Excel 1997 to 2003 will work in Excel 2007 and 2010 except for a few minor changes:
- a function used only by advanced users " FileSearch" does not exist anymore. It can be easily replaced by " Dir"
that runs in Excel 2007, 2010 and in earlier versions of Excel.
- Advanced users of Excel 2007 and 2010 who import external data with or without SQL might want to add these two lines of code at the end of the refresh process:
- Use the macro recorder to discover the new syntax to cells' background, font colors, filtering and sorting data.
Nothing else has changed in Excel 2007 and 2010 as far as VBA and macros are concerned.
The macro recorder and the Visual Basic Editor are the same.
Back to the top of the page