[Free ebook 2019]Microsoft VBA professional projects

The book is written by a long-time Excel user with significant programming and teaching experience, both of which provide the author the insight needed to present the topic in a manner that can be more easily understood by the reader. Microsoft Excel VBA Professional Projects uses practical examples of VBA-code included in useful and fully functional projects to better illustrate how and when to use specific tools. The book will not assume any prior knowledge of VBA programming. It will not intimidate intermediate-level programmers or patronize advanced programmers looking to learn a new language. The book will illustrate and teach intermediate to advanced techniques in VBA programming using Microsoft’s Excel spreadsheet application. It will provide an introduction to VBA and Excel-VBA before proceeding through four or five programming projects using Excel that illustrate basic and advanced programming techniques.

Duane Birnbaum began programming in graduate school, where he wrote custom software for interfacing the various electronic devices require for his experiments and analyzing the data obtained from them. Since completing his Ph.D. in physical chemistry, he has worked in academia and the biotech industry while continually teaching on a part-time basis. He has been serving as a part-time lecturer in computer science at Indiana University/Purdue University Indianapolis for seven years teaching courses in programming, data analysis, and database design.