Bovey / Bullen / Green Excel 2002 VBA

Programmers Reference
1. Auflage 2004
ISBN: 978-0-7645-5859-7
Verlag: John Wiley & Sons
Format: PDF
Kopierschutz: Adobe DRM (»Systemvoraussetzungen)

E-Book, Englisch, 1040 Seiten, E-Book

What is this book about?
VBA is the programming language for the Microsoft Office suiteand many other applications. VBA gives you complete control ofExcel, allowing you to do anything from automating Excel tasks todeveloping full applications, using Excel as the developmentenvironment.
Excel 2002 is an important upgrade to the Office suitespreadsheet program. It shows Microsoft's 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 VBAProgrammer's Reference, this new edition has been fully updatedfor Excel 2002. The authors are all Excel MVPs, involved daily insupporting the Excel VBA programmer community.
What does this book cover?
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.
Here are just a few of the things you'll learn in thisedition:
* 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
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.

Autoren/Hrsg.

Bovey, Rob

Bullen, Stephen

Green, John

Rosenberg, Robert

Inhaltsverzeichnis

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.

Über Autor(innen)

John Green works as an independent computer consultant andestablished his company, Execuplan Consulting, which specializes indeveloping computer based planning applications and in training.He's led training courses for software applications and operatingsystems and has been accorded the status of Most ValuableProfessional by Microsoft for his contributions to the CompuServeExcel forum and MS Internet newsgroups. Contact him [e-mail].
Stephen Bullen set-up his own company called BusinessModelling Solutions Ltd, which specialises in Excel and Accessdevelopment and consulting. The BMS web site contains a largenumber of examples of his work, including tools and utilities toextend Excel's functionality and many examples of Excel developmenttechniques. Stephen can be contacted by email [e-mail].
Rob Bovey is a software developer and is founder andpresident of the custom application development firm, ApplicationProfessionals. Rob developed several Addins shipped by Microsoftfor Excel. He also co-authored the Microsoft Excel 97 DevelopersKit. Microsoft has awarded him the title of Most ValuableProfessional each year since 1995.
Robert Rosenberg runs his own consulting business whichspecializes in Microsoft Office advanced training and customsolutions. As a Microsoft Valuable Professional in Excel, he alsocontinually offers advanced online support on Excel on behalf ofMicrosoft to users of their Internet newsgroups. Robert can becontacted on at [e-mail].