Excel 2002 VBA Programmer's Reference (June 2003 reprint)
Customer Reviews: 1 Average Customer Rating:  Write a Review and tell the world about this title! Books on similar topics, in best-seller order: Books from the same publisher, in best-seller order:
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 SmartTags 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.
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 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
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.
Table of Contents
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: PivotTables.
Chapter 8: Filtered Lists.
Chapter 9: Generating Charts.
Chapter 10: Event Procedures.
Chapter 11: Adding Controls.
Chapter 12: Office Files and Folders.
Chapter 13: UserForms.
Chapter 14: Command Bars.
Chapter 15: Class Modules.
Chapter 16: Addins.
Chapter 17: Automation Addins and COM Addins.
Chapter 18: SmartTags.
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.
About the Authors
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 CompuServe Excel
forum and MS Internet newsgroups. Contact him at jgreen@enternet.com.au.
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 Stephen@BMSLtd.co.uk.
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 rrosenberg@r-cor.com.
Customer Reviews
Customer Reviews: 1 Average Customer Rating: Sep 12, 2003 ed robinson (robinson@homechoice.co.uk) from england
excellent but not really for beginners
a very authoritive and comprehensive title. although the explanations are straightforward and lucid, this book is not really for beginners. This will go down as something of a classic.
|
