Definitive Guide to Excel VBA

This volume offers up-to-date coverage and provides in-depth coverage of topics normally overlooked, such as the File Scripting Objects, accessing external databases using the ADO library, automating data analysis with pivot tables and automating diagrams.