Excel 2007 VBA programmer's reference
This book is aimed squarely at Excel users who want to harness the power of the VBA language in their Excel applications. At all times, the VBA language is presented in the context of Excel, not just as a general application programming language. The Primer has been written for those who are new to...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, IN :
Wrox/Wiley
c2007.
|
| Edición: | 1st edition |
| Colección: | Wrox programmer's references.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009626864706719 |
Tabla de Contenidos:
- Excel 2007 VBA Programmer's Reference; About the Authors; Credits; Contents; Acknowledgments; Introduction; Chapter 1: Primer in Excel VBA; Chapter 2: The Application Object; Chapter 3: Workbooks and Worksheets; Chapter 4: Using Ranges; Chapter 5: Using Names; Chapter 6: Data Lists; Chapter 7: PivotTables; Chapter 8: Charts; Chapter 9: Event Procedures; Chapter 10: Adding Controls; Chapter 11: Text Files and File Dialog; Chapter 12: Working with XML and the Open XML File Formats; Chapter 13: UserForms; Chapter 14: RibbonX; Chapter 15: Command Bars; Chapter 16: Class Modules
- Chapter 17: Add-insChapter 18: Automation Add-Ins and COM Add-Ins; Chapter 19: Interacting with Other Office Applications; Chapter 20: Data Access with ADO; Chapter 21: Managing External Data; Chapter 22: The Trust Center and Document Security; Chapter 23: Browsing OLAP Data Sources with Excel; Chapter 24: Excel and the Internet; Chapter 25: International Issues; Chapter 26: Programming the VBE; Chapter 27: Programming with the Windows API; Appendix A: Excel 2007 Object Model; Appendix B: VBE Object Model; Appendix C: Office 2007 Object Model; Index
