Microsoft Excel VBA Professional Projects Book

Part 1: Introduction to VBA 1. VBA Overview and the IDE 2. Working with Variables and Constants in VBA 3. Using VBA's Built-in Functions 4. Using and Creating VBA Procedures 5. Program Branching with VBA Decision Structures 6. Creating VBA Loops and Arrays 7. VBA Objects Specific to Excel Programming 8. Understanding File I/O, and Debugging and Error Handling in VBA Part 2: Professional Project I: Worksheet-to-HTML Converter 9. Creating Custom Menus and Toolbars with VBA 10. Using VBA to Program Excel Charts 11. Creating Your Own VBA Objects with Class Modules 12. Constructing the Excel-to-HTML Converter Part 3: Professional Project II: Business Analyses for Pear-Tree Used Cars Inc. 13. Data I/O Between Excel and Access 14. Using and Creating Excel Pivot Tables for Fast Data Analyses 15. Constructing the Project: Business Analyses for Pear-Tree Used Cars Inc. Part 4: Professional Project III: Creating a Stock Ticker with VBA 16. Web Queries and Web-Related Objects in VBA 17. Enhancing VBA Programs Using the Windows API 18. Constructing the Stock Ticker Part 5: Professional Project IV: Data Analysis Automation and Curve-Fitting with Excel-VBA 19. Reducing the Workload by Automating Data Analyses 20. Advanced Data Analysis Using Curve-Fitting with Excel-VBA 21. Constructing the Project: Data Analysis Automation and Curve-Fitting with Excel-VBA Appendices: A: Basic Excel Tutorial B: Basic HTML/XHTML C: A Basic SQL