Using Excel Visual Basic for Applications

by Jeff Webb

Book Overview

Written by a former Senior Writer at Microsoft, this book shows the reader how to do everything from simple macro creation to powerful application development. Readers will be able to speed up the... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 078970269X
• ISBN13: 9780789702692
• Release Date: January 1996
• Publisher: Que
• Length: 868 Pages
• Weight: 3.55 lbs.
• Dimensions: 1.9" x 7.4" x 9.1"

Customer Reviews

Congratulations

Thank you very much. This was the first time that I had purchased something out of my country by Internet and every thing was attended. I would say to keep their work with this philosophy.

Excellent Reference

This book is a complete reference for all aspects of Excel VBA. A great source of information for beginners and experienced programmers.

Very clear, well organized, and comprehensive

An excellent reference book for programmers who have some basic familiarity with VBA. Webb does not drown his reader in pages of useless listings or chimpanzee instructions (Go to the Menu Bar, click File, click Open, click OK, duh) that have seemed to overtake so many other training books. Instead, he provides an intelligent tour of VBA. Might be outdated, but still worth it!

I keep coming back to it

I wanted to update my last review of this book. Since I last wrote, I have been doing a lot more Excel VBA coding and I find I keep coming back to this book. I also bought Walkenbach's "Excel for Windows 95" and Wells/Harshbarger's "Microsoft Excel 97 Developer's Handbook" and I use this one the most. I just wish it were updated for Excel 97 since VBA has changed. I find the VBA on line help in Excel 97 less helpful than in Excel 95 and when I turn to Webb's book, I find what I need!

A different slant on VBA

This is mainly a reference guide, but is structured differently to Microsoft's "official" guide, being very much built around the VBA for Excel "object model". Additionally, each chapter starts with an overview of the objects it documents, including their uses, and gives hints on how to succesfully use VBA. Appendices cover the constants used in VBA function calls, and their actual values, and also include information on accessing DLL's from VBA - for example to call the Windows API directly from VBA. This, and the Microoft "Excel 5 VBA Reference" make a very handy reference set for VBA programmers