did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

We're the #1 textbook rental company. Let us show you why.

9780764558597

Excel 2002 VBA : Programmers Reference

by ; ; ;
  • ISBN13:

    9780764558597

  • ISBN10:

    0764558595

  • Format: eBook
  • Copyright: 2004-08-01
  • Publisher: Wrox
  • Purchase Benefits
  • Free Shipping Icon Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
  • Write a Review Icon Write a Review
List Price: $85.00
We're Sorry.
No Options Available at This Time.

Summary

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 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. 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 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 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.

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.

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program