Definitive Guide to Excel VBA

by Michael Kofler (Author), D . Kramer (Translator)

• Used

  Paperback
  2000

  $27.47

  This text assumes no knowledge of VBA or Visual Basic and covers aspect of Excel programming. The emphasis is 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. 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 lots 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.

• New

  Paperback
  2003

  $46.32

  - Kofler's book offers more up-to-date coverage than other books on the market - 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.