Excel 2007 VBA Programmer's Reference
John Green, Stephen Bullen, Rob Bovey, Michael Alexander
- 出版商: Wrox Press
- 出版日期: 2007-03-01
- 售價: $1,680
- 貴賓價: 9.5 折 $1,596
- 語言: 英文
- 頁數: 1176
- 裝訂: Paperback
- ISBN: 0470046430
- ISBN-13: 9780470046432
-
相關分類:
Excel
已過版
買這商品的人也買了...
-
Head First Java, 2/e (Paperback)$2,220$2,109 -
敏捷軟體開發：原則、樣式及實務 (Agile Software Development: Principles, Patterns, and Practices)$780$616 -
深入淺出設計模式 (Head First Design Patterns)$880$695 -
API 環境下的 WIN32 程式設計 (Programming Win32 Under the API)$300$270 -
ASP.NET 2.0 深度剖析範例集$650$507 -
SQL 語法範例辭典$550$468 -
Microsoft Office SharePoint Server 2007 新一代企業 Web 解決方案(第一集)$690$587 -
Linux 驅動程式, 3/e (Linux Device Drivers, 3/e)$980$774 -
嵌入式設計及 Linux 驅動開發指南─基於 ARM9 處理器, 2/e$420$399 -
Computer Networking: A Top-Down Approach, 4/e(IE-paper)$1,100$1,078 -
深入淺出物件導向分析與設計 (Head First Object-Oriented Analysis and Design)$880$616 -
Visual C# 2005 程式設計經典$600$474 -
Windows Mobile 平台應用與開發$520$199 -
Pragmatic Software Testing: Becoming an Effective and Efficient Test Professional (Paperback)$1,960$1,862 -
ASP.NET AJAX 經典範例 100─使用 VB$750$593 -
C++ Primer, 4/e (中文版)$990$891 -
ASP.NET AJAX 應用剖析立即上手$580$452 -
Joomla 1.5.x 網站架設寶典$490$417 -
現代嵌入式系統開發專案實務－菜鳥成長日誌與專案經理的私房菜$600$480 -
Microsoft Visual Basic 2008 資料庫程式設計範例教本$650$553 -
Google Android 2.X 應用程式開發實戰$520$411 -
Google！Android 2 手機應用程式設計入門, 3/e$530$419 -
Google Android SDK 開發範例大全 2$890$757 -
深入淺出 Android 系統原理及開發要點$450$351 -
Windows 7 Inside Out , Deluxe Edition (Hardcover)$2,660$2,527
相關主題
商品描述
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).
