 |
Excel 2003 VBA Programmer's Reference
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: - Microsoft Office Excel 2007 Power Programming with VBA; John Walkenbach, $30.95, 38% Off!
- Microsoft Office Excel 2003 Power Programming with VBA; John Walkenbach, $31.50, 37% Off!
- Access 2003 VBA Programmer's Reference; Patricia Cardoza, et al, $25.50, 36% Off!
- Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA; Stephen Bullen, et al, $40.95, 37% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
- This updated and expanded Wrox resource covers how to gain more control
over Excel spreadsheets using VBA, enabling users to do anything from automating
Excel tasks to developing full applications while using Excel as the development
environment
- Brings readers up to speed with Excel and VBA, then expands to focus on
major issues faced by Excel users and developers
- Covers the basics such as setting up applications and converting them to
add-ins, packaging and distributing Excel applications, programming the VB
Editor, and using the Windows API
- The author was awarded as a Visual Developer MVP for his community contributions
in the primary area of Visual Basic.
- Contains more than 400 pages on new topics, and reference appendices are
now included on the Web in a downloadable and searchable format
Table of Contents
Introduction.
1. Primer in Excel VBA.
2. Programming in the VBA.
3. The Application Object.
4. Object Oriented Theory and VBA.
5. Event Procedures.
6. Class Modules.
7. Writing Bulletproof Code.
8. Debugging and Testing.
9. UserForms.
10. Adding Controls.
11. Data Access with ADO.
12. Creating and Using Add-ins.
13. Automation Addins and COM Addins.
14. Customizing the VBE.
15. Interacting with Other Office Applications.
16. Programming with the Windows API.
17. International Issues.
18. Workbooks and Worksheets.
19. Using Ranges.
20. Using Names.
21. Working with Lists.
22. PivotTables.
23. Filtered Lists.
24. Generating Charts.
25. Office Files and Folders.
26. Command Bars.
27. SmartTags.
28. Excel and the Internet.
29. XML and Excel.
Appendix A: Excel 2003 Object Model.
Appendix B: VBE Object Model.
Appendix C: Office 2003 Object Model.
|
|
