VBA and Macros for Microsoft Excel 2007

Download files for VBA and Macros for Microsoft Excel 2007

Thanks for buying VBA and Macros for Microsoft Excel 2007.

As an exclusive benefit to you, I've made all of the code from the book available for download.

Right-click any of the following files and choose "Save As" to download .zip files to your computer. The zip files contain Excel files saved in the Excel 2007 .XLSM file format. If you need files in the 2003 .XLS format, consider downloading similar files from the 2003 version of this book.

Note

Chapter 1 of the book talks about four different versions of a file called invoice.txt. Since there is not a good way to include all of those versions, I have pre-loaded invoice.txt into four tabs of the Chapter 1 workbook, and then commented out the one line of code that imports each day's invoice.txt. This will allow you to see the real point of the chapter - that the macro recorder does a lousy job of finding the last row of data.

Chapter 1 - The problem
Chapter 2 - Syntax of VBA
Chapter 3 - Referring to Ranges
Chapter 4 - User Defined Functions
Chapter 5 - Looping and Flow Control
Chapter 6 - R1C1 Style Formulas
Chapter 7 - What's New in Excel 2007
Chapter 8 - Names
Chapter 9 - Events
Chapter 10 - Userforms
Chapter 11 - Charts
Chapter 12 - Advanced Filter
Chapter 13 - Pivot Tables
Chapter 14 - Excel Power
Chapter 15 - Data Visualizations
Chapter 16 - Web
Chapter 17 - XML
Chapter 18 - Automating Word
Chapter 19 - Arrays
Chapter 20 - Text File Processing
Chapter 21 - Access
Chapter 22 - Classes
Chapter 23 - Userforms Advanced
Chapter 24 - Windows API
Chapter 25 - Handling Errors
Chapter 26 - Customizing the Ribbon
Chapter 27 - Creating Add-Ins

Thank you again for buying the book.

Mac Users

Several Mac users noted that they can not use the .exe version of the files. You can download the chapter by chapter examples from macvba.zip.