Brilliant Microsoft Excel 2007 VBA & Macros

Bill Jelen "Mr. Excel" is an accomplished Excel author and the principal behind the leading Excel website, MrExcel.com. As an Excel consultant, he has written Excel VBA solutions for hundreds of clients around the English-speaking world. His website hosts over 10 million page views annually. Prior to founding MrExcel.com, Jelen spent twelve years in the trenches, working as a financial analyst for finance, marketing, accounting and operations departments of a $500 million public company. Tracy Syrstad works as an Excel and Access Consultant. As part of the Mr.Excel.com Consulting team, she has helped develop VBA solutions for clients around the world. She remembers the painful trek up the VBA learning curve while developing applications for co-workers at a former job. She is co-editor of Holy Macro!, it's "600 Excel VBA Examples CD" and editor of Dreamboat On Word.

Introduction



Unleash the Power of Excel with VBA
This Sounds Like BASIC, So Why Doesn't It Look Familiar
Referring to Ranges
User-Defined Functions
Looping and Flow Control
R1C1-Style Formulas
What's New in Excel 2007 and What's Changed
Create and Manipulate Names in VBA
Event Programming
Userforms - An Introduction
Creating Charts
Data Mining with Advanced Filter
Using VBA to Create Pivot Tables
Excel Power
Data Visualizations and Conditional Formatting
Reading from and Writing to the Web
XML in Excel 2007
Automating Word
Arrays
Text File Processing
Using Access as a Back End to Enhance Multi-User Access to Data
Creating Classes, Records, and Collections
Advanced Userform Techniques
Windows Application Programming Interface (API)
Handling Errors
Customising the Ribbon to Run Macros
Creating Add-Ins

Index