∗ More than 400 task–oriented pages show intermediate–to–advanced users how to automate, customize, and integrate Excel using Visual Basic for Applications and VBA–based macros
∗ Crisp, two–color screen shots and succinct step–by–step instructions demonstrate how to create macros, add customized features to spreadsheets, and build powerful Excel–based applications
∗ Shows how to make macros "smart," create and customize VBA code, program Smart Documents, make Excel communicate efficiently with other applications, and more
∗ With VBA, users can buy Excel off the shelf and customize it to meet their specific business needs instead of building applications from scratch–saving users and businesses time and money
∗ All information is applicable to Excel versions 2000, 2002, and 2003
"One picture is worth a thousand words." If you prefer instructions that show you how rather than tell you why, then this intermediate to advanced level reference is for you. Hundreds of succinctly captioned, step–by–step screen shots reveal how to accomplish more than 180 Excel tasks with VBA programming, including:
- Writing and recording short macros
- Using all the VBA commands
- Automating charts, pivot tables, and more
- Adding digital signatures
- Debugging your code
- Specifying page setup settings
- Writing a function procedure