VBA and macros
Subtitle: Microsoft Excel 2010
By: Bill Jelen, Tracy Syrstad
Contributors: Syrstad, Tracy
Publisher: Que Pub.
Published: 2010
Place of publication: Indianapolis, Ind
Language: eng
ISBN-13: 9780789743145
Notes: Includes index.
Table of contents: title: Unleash the power of Excel with VBA; title: This sounds like basic, so why doesn't it look familiar?; title: Referring to ranges; title: User-defined functions; title: Looping and flow control; title: R1C1-style formulas; title: What's new in Excel 2010 and what's changed; title: Create and manipulate names in VBA; title: Event programming; title: Userforms, an introduction; title: Creating charts; title: Data mining with advanced filter; title: Using VBA to create pivot tables; title: Excel power; title: Data visualizations and conditional formatting; title: Reading from and writing to the web; title: XML in Excel 2007; title: Automating Word; title: Arrays; title: Text file processing; title: Using Access as a back end to enhance multi-user access to data; title: Creating classes, records, and collections; title: Advanced userform techniques; title: Windows application programming interface (API); title: Handling errors; title: Customizing the ribbon to run macros; title: Creating add-ins.