Tracy Syrstad remembers the painful trek up the VBA learning curve while developing applications for herself and co-workers at a former job. Now, as the project manager for the MrExcel consulting team, she enjoys helping clients develop custom solutions for their unique situations, observing the myriad ways people use Excel and other Microsoft Office applications.
Introduction | p. 1 |
Unleash the Power of Excel with VBA | p. 7 |
This Sounds Like BASIC, So Why Doesn't It Look Familiar? | p. 29 |
Referring to Ranges | p. 61 |
User-Defined Functions | p. 75 |
Looping and Flow Control | p. 101 |
R1C1-Style Formulas | p. 121 |
What's New in Excel 2007 and What's Changed | p. 135 |
Create and Manipulate Names in VBA | p. 143 |
Event Programming | p. 155 |
UserForms--An Introduction | p. 177 |
Creating Charts | p. 197 |
Data Mining with Advanced Filter | p. 249 |
Using VBA to Create Pivot Tables | p. 281 |
Excel Power | p. 337 |
Data Visualizations and Conditional Formatting | p. 373 |
Reading from and Writing to the Web | p. 393 |
XML in Excel 2007 | p. 413 |
Automating Word | p. 421 |
Arrays | p. 441 |
Text File Processing | p. 449 |
Using Access as a Back End to Enhance Multi-User Access to Data | p. 461 |
Creating Classes, Records, and Collections | p. 477 |
Advanced UserForm Techniques | p. 493 |
Windows Application Programming Interface (API) | p. 517 |
Handling Errors | p. 529 |
Customizing the Ribbon to Run Macros | p. 543 |
Creating Add-Ins | p. 569 |
Index | p. 577 |
Table of Contents provided by Publisher. All Rights Reserved. |
The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.