Rob Bovey & Stephen Bullen 
Excel 2002 VBA [PDF ebook] 
Programmers Reference

What is this book about?

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 Microsoft’s 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 Smart Tags
and XML support.

Based on the successful content and format of Excel 2000 VBA
Programmer’s 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.

What does this book cover?

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.

Here are just a few of the things you’ll learn in this
edition:

* The entire Excel Object Model and the Common Office Object
Model

* Working with Pivot Tables

* Accessing and manipulating data sources from Excel with
ADO

* Programming the Visual Basic Editor (VBE)

* New features in Excel 2002, Smart Tags, XML, and the Web

* Expanded references for Excel versions 97, 2000, and 2002

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.

Jadual kandungan

Chapter 1: Introduction to Excel.

Chapter 2: Primer in Excel VBA.

Chapter 3: The Application Object.

Chapter 4: Workbooks and Worksheets.

Chapter 5: Using Ranges.

Chapter 6: Using Names.

Chapter 7: Pivot Tables.

Chapter 8: Filtered Lists.

Chapter 9: Generating Charts.

Chapter 10: Event Procedures.

Chapter 11: Adding Controls.

Chapter 12: Office Files and Folders.

Chapter 13: User Forms.

Chapter 14: Command Bars.

Chapter 15: Class Modules.

Chapter 16: Addins.

Chapter 17: Automation Addins and COM Addins.

Chapter 18: Smart Tags.

Chapter 19: Interacting with Other Office Applications.

Chapter 20: Data Access with ADO.

Chapter 21: Excel and the Internet.

Chapter 22: International Issues.

Chapter 23: Programming the VBE.

Chapter 24: Programming with the Windows API.

Appendix A: Excel 2002 Object Model.

Appendix B: VBE Object Model.

Appendix C: Office XP Object Model.

Mengenai Pengarang

John Green works as an independent computer consultant and
established his company, Execuplan Consulting, which specializes in
developing computer based planning applications and in training.
He’s led training courses for software applications and operating
systems and has been accorded the status of Most Valuable
Professional by Microsoft for his contributions to the Compu Serve
Excel forum and MS Internet newsgroups. Contact him at
[email protected].

Stephen Bullen set-up his own company called Business
Modelling Solutions Ltd, which specialises in Excel and Access
development and consulting. The BMS web site contains a large
number of examples of his work, including tools and utilities to
extend Excel’s functionality and many examples of Excel development
techniques. Stephen can be contacted by email to
[email protected].

Rob Bovey is a software developer and is founder and
president of the custom application development firm, Application
Professionals. Rob developed several Addins shipped by Microsoft
for Excel. He also co-authored the Microsoft Excel 97 Developers
Kit. Microsoft has awarded him the title of Most Valuable
Professional each year since 1995.

Robert Rosenberg runs his own consulting business which
specializes in Microsoft Office advanced training and custom
solutions. As a Microsoft Valuable Professional in Excel, he also
continually offers advanced online support on Excel on behalf of
Microsoft to users of their Internet newsgroups. Robert can be
contacted on at [email protected].