Excel 2000 Developer's Handbook [With *]

by Marion Cottingham

An introduction to Excel VBA programming. The text shows developers how to create timesaving, productivity-enhancing macros based on Visual Basic for Applications (VBA) and write code in VBA. It shows how to make bug-free forms and graphs by automating a spreadsheet using VBA. A CD is included.

• Format: Paperback
• Language: English
• ISBN: 0782123287
• ISBN13: 9780782123289
• Release Date: January 1999
• Publisher: Sybex
• Length: 862 Pages
• Weight: 3.45 lbs.
• Dimensions: 2.3" x 7.5" x 9.0"

Customer Reviews

A Must Have Resource

This is a must have book for those who are advanced users of Excel. You do not have to be a programmer to appreciate the advice and instruction found between the pages of this reference book. Gaining an understanding of VBA can only expand your Excel skills. This tool can assist even the beginner with adding automation to their Workbooks. Even if you only write your macros to complete the mundane tasks and save time, this book is an excellent guide.Chris ...

Simply the Best

This is the book I've been waiting for. I develop small applications for a variety of clients to streamline their operations. Some of them have quite a high turnover of staff so it is very important that new staff have access to some help when they run my applications. This book showed me how to control the office assistant so that helpful text is given at the time the user needs it. I haven't seen this in other Excel VBA books. I also know how to build a full-blown help facility for larger projects - also missing from other books. I also found it helpful for Web based projects as it shows how to spruce up excel spreadsheet for web publication - and how to publish them too! As you can tell I'm really excited about this book. It has been worth it's weight in gold as I've used quite a lot of the material from the CD with moderate adjustments - and it all works too!

A Reader

This is the book for me! I was an Excel user that wanted to start writing macros but didn't know where to start. I have now achieved this and I've macro-ized as the author puts it all my mundane tasks and I'm now onto Web publishing and making the Office Assistant dance and say helpful things while my application runs. It's the only book I know that shows how to develop a Help facility. Yes I've got to the end and feel I've achieved so much!