Definitive guide to excel vba

- Substantial, up-to-date coverage of Excel VBA and VBA functions - Covers important yet often overlooked topics such as the File Scripting Objects, accessing external databases using the ADO library, and automating diagrams Michael Kofler has written a book that serves not only as a reference, but also focuses on solutions to frequently occurring problems. Kofler introduces Excel programming, and then provides a systematic explanation of VBA and the Excel object library in a problem-solving mode. He covers all of the essential topics in Excel programming from automatically displaying different views of data to accessing databases through ADO. Compact syntax references at the end of each chapter offer the overview not provided by Microsoft's official documentation. About the Author Michael Kofler earned his Ph.D. in Computer Science at Graz Technical University. He has written a number of successful computer books on topics such as Visual Basic, VBA programming for Excel, Linux, Mathematica, and Maple.