VBA for Excel (Macros)

VBA stands for Visual Basic for Applications. It is the simple programming language that can be used within Excel to develop macros and complex programs:

This website is designed for users of Excel 1997 to 2007

There are more than 100 great FREE ideas and tips
introducing you to the 33 lessons
of the Downloadable Tutorial

10 Lessons on the Programming Tools

13 Lessons on Excel Macros Vocabulary

10 Lessons on Excel Userforms

Mentoring and Consulting Services in Excel and VBA

Serving clients online in USA and Canada for the past 15 years
Mobile: 613-749-4695 (Peter)
Email: peter@excel-vba.com

Merk Pharmaceutical (New Jersey ), Proctor Financial (Massachusets), Delray Investements (Florida),Gibraltar Bank and Trust (Florida), SCI (Texas), Microsoft Corporation (Washington), Bombardier (Valcourt), National Bank of Canada (Toronto), Gildan Activewear (Montreal), Atlas Paper Mills (Florida) and many small business owners, investors and free lance professionals around the world.

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