Kravatz Inc.'s Guide To Excel VBA Macros

Titles

Table of Contents

1. Introduction
2. Programming 101
3. Programming rules
4. Excel Review
5. Excel VBA Macros
6. Debugging
7. User Interface
8. Mistakes To Avoid
9. Working With Files
10. Working With Databases
11. Getting Data from the Internet
12. Excel Automation
13. Windows API
14. Email
15. Error Handling
16. Formatting Your Output
17. Controling the VBE (Visual Basic Editor)
18. Creating a DLL
19. Financial Knowledge
20. Interfacing with other systems
21. Software Development Skills

Other Information

• Copy/Clipboard_Problem.htm
• Sharing Code amongst Multiple developers
• Accidental Sheet Deletion/Clearing
• Saving back versions of your code
• Recording Macros
• Monte Carlo Simulations
• ThisWorkbook.name
• Templates

• Free Excel Code
  
• Excel Tools
  
• Links
Contact
• Free Estimate
• Legal