VBA for Excel (Macros)

VBA for Excel (Macros) for Beginners, Intermediate and Advanced Users

To use VBA or any other language you need vocabulary
Here is the vocabulary that you need when:

All the words used by the author while developing business applications for his clients over the last 10 years including Merck Pharmaceutical, Atlas Paper Mills, Bombardier, Proctor Financial, Gibraltar Bank  & Trust and many individual business data analysts around the USA and Canada.

Working with the Application

Working with Worbooks

Working with worsheets

Working WITHIN Worksheets

Working with Message and Input Boxes

Working with Excel Databases and Filters

Working with Statements

Working with Functions

Working with Variables

Working with External Data and SQL

Working with Other Programs

Handling errors

General Coding Tips

VBA Macros in Excel 2007

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