Michael Kofler, «Definitive Guide to Excel VBA», Second Edition
Apress | ISBN 1590591038 | 2003 Year | CHM | 936 Pages | 21 Mb
This book is definitive. Though assuming no knowledge of VBA or Visual Basic, it covers every aspect of Excel programming. The emphasis is always on solving problems that professionals will encounter in their daily work. Whether it is automatically displaying different views of data through pivot tables or accessing databases through ADO, the latest Microsoft database technology, it's all here. The final chapter provides a reference on Excel objects that is equally definitive. It is important to note that this book is not an advertising brochure for Excel. If there are problems with the Excel object library (and unfortunately there are many of them), they are explained. Whenever possible, Kofler explains a work-around. Still, this book gives the reader a comprehensive look at what you can do with Excel - and despite some problems, the range of possible applications is huge.
Guide shows how to write Excel code efficiently, how to access external databases, how to analyze and visualize complex data automatically, and how to build menus and dialogs. Translated from the original text in German.
No mirror links please!