VBA is the programming language for the Microsoft® Officesuite and many other applications. VBA gives you complete controlof Excel, allowing you to do anything from automating Excel tasksto developing full applications, using Excel as the developmentenvironment.
Excel 2002 is an important upgrade to the Office suitespreadsheet program. It shows Microsofts commitment to movingOffice to be a web-enabled productivity tool, a rich client forworking with web-based data, with new features such as SmartTagsand XML support.
Based on the successful content and format of Excel 2000 VBAProgrammers Reference, this new edition has been fullyupdated for Excel 2002. The authors are all Excel MVPs, involveddaily in supporting the Excel VBA programmer community.
The first part of the book introduces Excel and VBA, including aVBA primer. The second part offers thematic, succinct, andpractical discussions of the features available to Excel VBAprogrammers, with real-world examples answering frequently askedquestions. The third and final part is a complete reference to theExcel, VBE, and Common Office Object Models.
Who is this book for?
This book not only caters for beginner and intermediate-levelprogrammers with its introductory coverage of VBA and Excel, butalso provides advanced information for experienced Excel developersin later chapters and the reference.
What does this book cover?
- The entire Excel Object Model and the Common Office ObjectModel
- Working with PivotTables
- Accessing and manipulating data sources from Excel withADO
- 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 newtechnology fast. Without the marketing hype, without the trivialintroduction. Thats what Wrox Programmers Referencesdeliver. Hard facts on the newest technologies with practicalexamples of how to apply new tools to your development projectstoday.