Synopses & Reviews
Microsoft Excel VBA Professional Projects illustrates and teaches intermediate to advanced techniques in VBA programming using Microsoft's Excel spreadsheet application. It provides an introduction to VBA and Excel VBA before proceeding through four to five programming projects using Excel to illustrate basic and advanced programming techniques. It does not assume any prior knowledge of Excel VBA programming.
About the Author
Duane Birnbaum received a Ph.D from the University of California, Riverside in 1991 in physical chemistry. He works at Biogel Technology as a research scientist and has authored numerous scientific articles in the areas of chemical physics, biochemistry, and chemical engineering. He began teaching part-time in the computer science department of Indiana University - Purdue University at Indianapolis in 1997, focusing on an introductory course in data analysis with an emphasis on using the tools in spreadsheet applications. Duane lives in Indianapolis, Indiana.
Table of Contents
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