VBA and macros for Microsoft Office Excel 2007
"This book shows you why the macro recorder fails and the steps needed to convert recorded code into code that will work every day with every dataset. The book assumes that you know Excel well, but there is no need for prior programming experience. This book describes everything you could conce...
| Main Author: | |
|---|---|
| Other Authors: | |
| Format: | eBook |
| Language: | English |
| Published: |
Indianapolis, Ind.
Que
2007
|
| Series: | Business solutions
|
| Subjects: | |
| Online Access: | |
| Collection: | O'Reilly - Collection details see MPG.ReNa |
Table of Contents:
- 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