 |
Excel 2000 VBA Programmer's Reference (June 2003 reprint) View Larger Image | John Green
Wrox Press, Paperback, Published June 1999, 715 pages, ISBN 0764544012 | List Price: $29.99
Our Price: $18.95
You Save: $11.04 (37% Off)
| | | Availability: Out-Of-Stock |
Be the First to Write a Review and tell the world about this title!Books on similar topics, in best-seller order: Books from the same publisher, in best-seller order:
Excel 2000 is an import part of the Office 2000 program suite, and will be available
in the Premium, Professional, Standard and Small Business editions of Office 2000.
Excel has traditionally been the Office suite spreadsheet program par excellence.
It still remains that way, but with Office 2000 there is a strong emphasis on
between-application automation, ease of use, and the smart new bells and whistles
that 2000 brings. Using VBA (Visual Basic for Applications), the user can program
his or her own programs in what is essentially a subset of the Visual Basic programming
languages. This is tremendously powerful, as it allows you to create great User
Interfaces (forms etc), as a front end to actual spreadsheet and database storage
and manipulation. This continues to be one of the great strengths of programming
Excel VBA. This book presents a full reference to the Excel object model, which
is essentially the object-oriented system of organizing the functional capacities
that make up the Excel program. There will be a short introduction to VBA itself,
and the rest of the book will document aspects of programming Excel through that
object model. This book will be in three broad sections: the first part introduces
Excel and VBA; the second offers interesting, thematic discussions of some of
the capacities available to Excel VBA. The third and final part offers a full
reference to the object model of Excel.
Table of Contents
Chapter 1: Introduction.
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: Filtered Lists.
Chapter 8: Generating Charts.
Chapter 9: Event Procedures.
Chapter 10: Adding Controls.
Chapter 11: UserForms.
Chapter 12: Command Bars.
Chapter 13: Class Modules.
Chapter 14: Addins.
Chapter 15: Interacting with other Office Applications.
Chapter 16: International Issues.
Chapter 17: Programming the VBE.
Chapter 18: Programming with the Windows API.
Appendix A: Excel 2000 Object Model.
Appendix B: VBE Object Model.
|
|
