Cargando…

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...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Bullen, Stephen
Otros Autores: Bovey, Rob, Green, John, 1945-
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.