Microsoft 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. 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. Incorporating four hands-on projects, Microsoft Excel VBA Professional Projects is your key to unlocking the power of Excel VBA. Each project focuses on a specific concept and is based on a real-world situation. You will be able to use the skills that you develop throughout the book to modify the projects to fit your professional needs. The goal of this book is to provide a solid introduction to the VBA programming language and show how it can be applied to create practical applications for Excel.