Excel 2002 Power Programming with VBA

This book is an excellent resource for getting up to speed using streamlined spreadsheet creation tools, enhanced analysis tools and powerful Web integration. Transform Excel into an application suited to the whole organization so workgroups can work more effectively. Discover how developers can integrate information seamlessly, whether proposal text, financial figures or research data. Whether you are an expert or a novice, Excel 2002 Power Programming with VBA will help you work more efficiently, turning your data into answers you can count on.

Bonus: The book contains a coupon for the Professional Power Utility Pak.

I've taught myself multiple computer languages (English is my natural language but that doesn't really matter now, does it?) and am very familiar with Excel -- but not so much on the programming side of things. As far as being a VB programmer, well, about two or three years ago I taught myself VB 5.0 and then never ended up needing to use it. The first time I used this book was to help me with a VB module in a customers Excel workbook. There was even an example in this book about using the Windows API to get the window to search for a directory which I was able to easily incorporate into the code. I then started reading through the chapters and just kept on learning more and more! When working on a project I can easily find a relevant chapter/section that pertains to what I'm doing or need and solve my problem!

He clearly explains his code and if the example is a code snipet. The included CD contains his examples and other files which I find very helpful, especially when I don't want to type in everything myself :-)

If you even *think* this may be a candidate for your library then stop thinking and just get it!


Bravo!   February 7, 2004
ex_student (Valley Center, CA United States)
2 out of 3 found this review helpful

Outstanding reference and how to manual for Excel macro programming. A must have for anyone who has ambitions of writing their own programs for Excel. John's clear, organized, and comprehensible writing style allows even a novice programmer to immediately begin to write Excel macros that really do something, and do something useful. His book is chock full of useful code examples. Get two copies. It is that good.


Excellent reference book for non-programmers   October 15, 2003
3 out of 4 found this review helpful

This book can be included in the handy tool category, a "must have" for non-programmers who want to give their Excel applications a professional look as well as get the most out of Excel without wasting much time and effort. Word of caution, a bit of familiarity with visual basic as a language and the controls etc. will be very helpful in using this book. Codes in the CD are very helpful. It is written by a practicing professional from usage point of view hence a very easy reading book and not heavy on the jargons of object oriented programming etc. I learned a lot of useful tricks after going through the book.