Using the Books CD


image from book 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.



Microsoft Office Excel 2007 Visual Basic for Applications Step by Step
Microsoft Excel 2002 Visual Basic for Applications Step by Step (Step by Step (Microsoft))
ISBN: 0735613591
EAN: 2147483647
Year: 2004
Pages: 99
Authors: Reed Jacobsen

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net