VBA is the programming language for the Microsoft® Office suite and
many other applications. VBA gives you complete control of Excel,
allowing you to do anything from automating Excel tasks to
developing full applications, using Excel as the development
environment.
Excel 2002 is an important upgrade to the Office suite
spreadsheet program. It shows Microsofts commitment to moving
Office to be a web-enabled productivity tool, a rich client for
working with web-based data, with new features such as SmartTags
and XML support.
Based on the successful content and format of Excel 2000 VBA
Programmers Reference, this new edition has been fully updated for
Excel 2002. The authors are all Excel MVPs, involved daily in
supporting the Excel VBA programmer community.
The first part of the book introduces Excel and VBA, including a
VBA primer. The second part offers thematic, succinct, and
practical discussions of the features available to Excel VBA
programmers, with real-world examples answering frequently asked
questions. The third and final part is a complete reference to the
Excel, VBE, and Common Office Object Models.
Who is this book for?
This book not only caters for beginner and intermediate-level
programmers with its introductory coverage of VBA and Excel, but
also provides advanced information for experienced Excel developers
in later chapters and the reference.
What does this book cover?
- The entire Excel Object Model and the Common Office Object
Model
- Working with PivotTables
- Accessing and manipulating data sources from Excel with
ADO
- Programming the Visual Basic® Editor (VBE)
- New features in Excel 2002, SmartTags, XML, and the Web
- Expanded references for Excel versions 97, 2000, and 2002
As an experienced developer, you need to get the facts on a new
technology fast. Without the marketing hype, without the trivial
introduction. Thats what Wrox Programmers References deliver.
Hard facts on the newest technologies with practical examples of
how to apply new tools to your development projects today.