|
Excel VBA Professional Projects
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.
Features
Will contain many code examples to illustrate how to use the various programming tools.
Screen shots will be used liberally along with code samples to illustrate the use of various programming tools.
Professional Projects is the only series that offers a project-oriented approach for high-end programmers.
The companion Web site will contain all of the book's source code which can be easily downloaded.
Table of Contents:
Part I - Introduction to VBA
Chapter 1: VBA Overview and the IDE
Chapter 2: Working with Variables and Constants in VBA
Chapter 3: Using VBA's Built-in Functions
Chapter 4: Using and Creating VBA Procedures
Chapter 5: Program Branching with VBA Decision Structures
Chapter 6: Creating VBA Loops and Arrays
Chapter 7: VBA Objects Specific to Excel Programming
Chapter 8: Understanding File I/O, and Debugging and Error Handling in VBA
Part II - Professional Project I: Worksheet-to-HTML Converter
Chapter 9: Creating Custom Menus and Toolbars with VBA
Chapter 10: Using VBA to Program Excel Charts
Chapter 11: Creating Your Own VBA Objects with Class Modules
Chapter 12: Constructing the Excel-to-HTML Converter
Part III - Professional Project II: Business Analyses for Pear-Tree Used Cars Inc.
Chapter 13: Data I/O Between Excel and Access
Chapter 14: Using and Creating Excel Pivot Tables for Fast Data Analyses
Chapter 15: Constructing the Project: Business Analyses for Pear-Tree Used Cars Inc.
Part IV - Professional Project III: Creating a Stock Ticker with VBA
Chapter 16: Web Queries and Web-Related Objects in VBA
Chapter 17: Enhancing VBA Programs Using the Windows API
Chapter 18: Constructing the Stock Ticker
Part V - Professional Project IV: Data Analysis Automation and Curve-Fitting with Excel-VBA
Chapter 19: Reducing the Workload by Automating Data Analyses
Chapter 20: Advanced Data Analysis Using Curve-Fitting with Excel-VBA
Chapter 21: Constructing the Project: Data Analysis Automation and Curve-Fitting with Excel-VBA
Appendix A: Basic Excel Tutorial
Appendix B: Basic HTML/XHTML
Appendix C: A Basic SQL
|
