VBA and macros for Microsoft Excel /

Everyone is looking for ways to save money these days. That can be hard to do for businesses that have complex needs, such as custom software applications. However, VBA and Macros for Microsoft Excel can teach you ways to customize pre-existing software to meet your specific needs. A variety of topi...

Full description

Bibliographic Details
Call Number:Libro Electrónico
Main Author: Jelen, Bill
Other Authors: Syrstad, Tracy
Format: Electronic eBook
Language:Inglés
Published: Indianapolis, IN : Que Pub., ©2004.
Series:Business solutions.
Subjects:
Microsoft Excel (Computer file)
Microsoft Visual Basic for applications.
Microsoft Visual Basic for applications
Business > Computer programs.
Electronic spreadsheets.
Tableurs.
COMPUTERS > Desktop Applications > Spreadsheets.
Business > Computer programs
Electronic spreadsheets
Commerce.
Business & Economics.
Marketing & Sales.
Online Access:Texto completo (Requiere registro previo con correo institucional)
Table of Contents:
  • I. First steps up the VBA learning curve
  • 1. Unleash the power of excel with VBA!
  • 2. This sounds like BASIC, so why doesn't it look familiar?
  • 3. Referring to ranges
  • 4. User-defined functions
  • 5. Looping
  • 6. R1C1 style formulas
  • 7. Names
  • 8. Event programming
  • 9. Userforms
  • an introduction
  • II. Automating excel power in VBA
  • 10. Charts
  • 11. Data mining with advanced filter
  • 12. Pivot tables
  • 13. Excel power
  • 14. Reading from and writing to the web
  • 15. XML in excel 2003 professional
  • 16. Automating word
  • III. Techie stuff you will need to produce applications for the administrator to run
  • 17. Arrays
  • 18. Text file processing
  • 19. Using access as a back end to enhance multi-user access to data
  • 20. Creating classes, records, and collections
  • 21. Advanced userform techniques
  • 22. Windows application programming interface (API)
  • 23. Handling errors
  • 24. Using custom menus to run macros
  • 25. Add-ins
  • 26. Case study
  • designing an excel application.

Similar Items