Excel 2007 VBA Programmer's Reference

John Green, Stephen Bullen, Rob Bovey, Michael Alexander

  • 出版商: Wrox Press
  • 出版日期: 2007-03-01
  • 售價: $1,640
  • 貴賓價: 9.5$1,558
  • 語言: 英文
  • 頁數: 1176
  • 裝訂: Paperback
  • ISBN: 0470046430
  • ISBN-13: 9780470046432
  • 相關分類: Excel
  • 已過版

買這商品的人也買了...

商品描述

Description

  • Fully updated and expanded to cover Microsoft Office Excel 2007, this book is aimed at Excel users who want to gain more control over their spreadsheets using VBA or who want to develop Excel applications.
  • Begins with an overview of VBA, the programming language for the Microsoft Office suite and many other applications, which allows users to do anything from automating Excel tasks to developing full applications with Excel as the development environment.
  • The book then expands to focus on major issues faced by advanced Excel users and developers, such as setting up applications and converting them to add-ins, packaging and distributing Excel applications, and advanced debugging and handling techniques.
  • Features a reference section downloadable from the Web for easy perusal.

 

Table of Contents

Foreword.

Preface.

Acknowledgements.

Author Bios.

Introduction.

1. Primer in Excel VBA.

2. The Application Object.

3. Workbooks and Worksheets.

4. Using Ranges.

5. Using Names.

6. Filtered Lists.

7. Pivot Tables.

8. Generating Charts.

9. Event Procedures.

10. Adding Controls.

11. Text Files and File Dialog.

12. Working with XML and the Open XML File Formats.

13. Userforms.

14. The Ribbon.

15. Command Bars.

16. Class Modules.

17. Addins.

18. Automation Addins and COM Addins.

19. Interacting with Other Office Applications.

20. Data Access with ADO.

21. Managing External Data.

22. The Trust Center and Document Security.

23. Interacting with OLAP Data Sources.

24. Excel and the Internet.

25. International Issues.

26. Programming the VBE.

27. Programming with the Windows API.

Appendix A. Excel 2002 Object Model

Appendix B. VBE Object Model.

Appendix C. Office XP Object Model.

Index.

L. License Agreement(S).