Vba And Macros For Microsoft Office Excel 2007

The perfect tool for learning to automate Excel and customize existing software to meet specific business needs!

Bill Jelen, Excel MVP and MrExcel, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. Bill has made more than 50 guest appearances on Call for Help with Leo Laporte and has produced more than 250 episodes of his daily video podcast, Learn Excel from MrExcel. He is the host of Total Training’s Excel 2007 Advanced DVD. He also enjoys taking his show on the road, doing a one- to four-hour power Excel seminar anywhere that a room full of accountants or Excellers will show up. Before founding MrExcel.com, Jelen spent 12 years in the trenches–working as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company. He lives near Akron, Ohio, with his wife, Mary Ellen, and sons, Josh and Zeke.

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.

What is included with this book?

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.

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Vba And Macros For Microsoft Office Excel 2007

Summary

Author Biography

Table of Contents

Supplemental Materials