Professional Excel development : the definitive guide to developing applications using Microsoft Excel and VBA /
Finally, there's a book that treats Excel as the powerful development platform it really is, and covers every facet of developing commercial-quality Excel applications. This is not a book for beginners. Writing for professional developers and true Excel experts, the authors share insider's...
Clasificación: | Libro Electrónico |
---|---|
Autor principal: | |
Otros Autores: | , |
Formato: | Electrónico eBook |
Idioma: | Inglés |
Publicado: |
Upper Saddle River, NJ ; London :
Addison-Wesley,
©2005.
|
Temas: | |
Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- Ch. 1. Introduction
- Ch. 2. Application architectures
- Ch. 3. Excel and VBA development best practices
- Ch. 4. Worksheet design
- Ch. 5. Function, general and application-specific add-ins
- Ch. 6. Dictator applications
- Ch. 7. Using class modules to create objects
- Ch. 8. Advanced command bar handling
- Ch. 9. Understanding and using Windows API calls
- Ch. 10. Userform design and best practices
- Ch. 11. Interfaces
- Ch. 12. VBA error handling
- Ch. 13. Programming with databases
- Ch. 14. Data manipulation techniques
- Ch. 15. Advanced charting techniques
- Ch. 16. VBA debugging
- Ch. 17. Optimizing VBA performance
- Ch. 18. Controlling other Office applications
- Ch. 19. XLLs and the C API
- Ch. 20. Combining Excel and Visual Basic 6
- Ch. 21. Writing add-ins with Visual Basic 6
- Ch. 22. Using VB.NET and the Visual studio tools for Office
- Ch. 23. Excel, XML and Web services
- Ch. 24. Providing help, securing, packaging and distributing.