Using the Books CD

CD Content

The companion CD included with this book contains the practice files you’ll use as you work through the book’s exercises, as well as other electronic resources that will help you learn how to use VBA macros with Microsoft Office Excel 2007.

What’s on the CD?

The following table lists the practice files supplied on the book’s CD. Note that some practice files are used in more than one chapter.

Tip 

The ExcelVBA07SBS folder contains a subfolder named Finished. This folder contains the finished version of each chapter’s workbook. The Finished folder is never explicitly referred to in the text, but it is there for your reference. If you have trouble getting a macro to work properly, you can look at the macros in the Finished folder to help troubleshoot the problem.

Open table as spreadsheet

Chapter	In the ExcelVBA07SBS folder	In the Finished folder
Chapter 1: Make a Macro Do Simple Tasks	Budget.xlsx	Chapter01.xlsm
Chapter 2: Make a Macro Do Complex Tasks	Nov2007.txt Orders.xlsx	Chapter02.xlsm
Chapter 3: Explore Workbooks and Worksheets	None	None
Chapter 4: Explore Range Objects	Ranges.xlsx	Chapter04.xlsm
Chapter 5: Explore Data Objects	Orders.xlsx Orders.accdb	Chapter05.xlsm
Chapter 6: Explore Graphical Objects	Graphics.xlsx MakeLogo.txt MakeMap.txt	Chapter06.xlsm
Chapter 7: Control Visual Basic	Flow.xlsx Flow.txt	Chapter07.xlsm
Chapter 8: Extend Excel and Visual Basic	Structure.txt	Chapter08.xlsm
Chapter 9: Launch Macros with Events	Events.txt	Chapter09.xlsm
Chapter 10: Use Dialog Box Controls on a Worksheet	Loan.xlsx	Chapter10.xlsm
Chapter 11: Create a Custom Form	Budget.xlsx	Chapter11.xlsm
Appendix: A Complete Enterprise Information System	EIS.xlsm Orders.accdb	None

Important 

The companion CD for this book does not contain the Microsoft Office Excel 2007 software. You should purchase and install that program before using this book.