Includes index.
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
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
Customizing the ribbon to run macros
Creating add-ins.
OBNB doesn't sell books, but you may be able to find a copy at one of these websites:
VBA and macros for Microsoft Office Excel 2007 by Bill Jelen. ISBN 9780789736826. Published by Que in 2008. Publication and catalogue information, links to buy online and reader comments.
