Excel 2007 VBA Programmer's Reference (Programmer to Programmer) |  | Authors: John Green, Stephen Bullen, Rob Bovey, Michael Alexander
Publisher: Wrox
List Price: $39.99
Buy New: $21.97
as of 11/25/2009 02:18 CST details
You Save: $18.02 (45%)
New (42) Used (17) from $20.49
Seller: new_books_today
Rating:  8 reviews
Sales Rank: 53284
Media: Paperback
Pages: 1176
Number Of Items: 1
Shipping Weight (lbs): 3.4
Dimensions (in): 9.2 x 7.2 x 2.2
ISBN: 0470046430
Dewey Decimal Number: 005.54
EAN: 9780470046432
ASIN: 0470046430
Publication Date: March 26, 2007
Availability: Usually ships in 1-2 business days
| |
| Features:
|
| Also Available In:
|
| Similar Items:
| |
| Editorial Reviews:
Product Description
Get ready to take your Excel applications to the next level by harnessing the power of the VBA language. This comprehensive resource will help you gain more control over your spreadsheets by using VBA while also showing you how to develop more dynamic Excel applications for other users. From introductory concepts to advanced developer topics, it guides you through every aspect of Excel 2007, including the Ribbon and the XML file formats.
|
| Customer Reviews:
Showing reviews 1-5 of 8
 It's called a Programmer's Reference, but it's not August 20, 2009
Another Weekend Warrior (Purdys, NY USA)
3 out of 4 found this review helpful
Programming books usually take one of three approaches. It either assumes you know absolutely nothing and gives you a very exhaustive history of not only the subject at hand, but programming in general. Or, the book is written "cookbook" style. Finally, some programming books are written as reference books.
This book claims to be a reference book, but it's not. As someone who's programmed for over a decade in a ton of languages and just had to learn enough to get this project done, I wanted a reference book so that I could say, "how do you write an 'if' statement?" "What's the syntax for logical operators in this language?" Stuff like that. You will find *none* of that in this book's index or table of contents.
For example, I had to write a simply if block. if ((condition A) and (condition B) Then 'Do something
I didn't know if the "and" was supposed to be && or AND or something else. So I looked up "logical operators" in the index. Nothing. So I then looked up just "operators". Nothing! Google to the rescue!
I needed to know how to increment a variable. In many languages (Perl, C/C++, PHP), if you have a variable named x, incrementing it would be as simple as x++. I may be wrong, but it doesn't appear that can be done in VBA and you'd have to do x = x + 1. It would be nice if there was a section quickly explaining this stuff.
There are a TON of examples such as this. For example, the books talks about functions. None of the examples, however, show you how to return a value from a function. The syntax is different than in most other languages, so it should at least be given a small mention. Again, google to the rescue!
In some cases, although you can't find it in the table of contents or the index, it *is* in the book. Of course, this then forces you to just aimlessly search from page to page trying to find what you need. For this project I'm doing, because I know nothing of this new language every page teaches me something I didn't know. So I found myself putting post it notes on pages. "Well, I'll need this bit of information to finish this project so let me just bookmark it. Right now, however, I'm looking for X and I still can't find that."
Listen, there is information in there and if you know nothing of VBA, you'll get something from this book (the only reason why I didn't give it 1 star). However, I bought it specifically because it said it was a reference. When I want to know the answer to something, I want a concise, quick way to look up how to do it so that I can move on. Unix Powertools is the PERFECT example of such a book and is probably the best cross-referenced book I ever read. In the end, I should have just saved my money and used google. I'll be returning this book.
 Didn't know a lick of VBA of ANY type going in February 20, 2009
Bill R. O. Neal (Cleveland, Ohio)
2 out of 2 found this review helpful
I used this book to finalize an Excel project promised to a client that I soon realized would require some kind of programming. I do have a programming background and I think that always helps, but I think even w/o that, this book may just do the trick for anybody (It even has a section to teach some basic programming skills and show these skills using VBA for Excel.)
The project was successful only because of this book (and my hard work! - but we're not reviewing that here! ;-)
Worth every pennny.
 Perfect for the impatient programmer who needs to pick up Excel VBA January 1, 2009
Nada Amin (Cambridge, MA, USA)
2 out of 2 found this review helpful
This is the best book I've found to quickly learn Excel VBA. I am an experienced programmer but I had no knowledge of VBA before reading this book. The book gives instant gratification with useful samples that are easily adapted. It teaches by example and still manages to get general and useful techniques across. In short, for my purpose (quickly picking up Excel VBA without getting terribly bored), this book is perfect.
Smaple you need to pay for! December 4, 2008
Rodney A. Biser
0 out of 15 found this review helpful
When I buy a book I think I going to get HELP NOT frustrated! They make the book cheap then make you buy the most importation one. It's like selling you crack for $1 and when you're hooked then make you pay $1,000 for more.
Pretty good book if you have background in programming with other language October 30, 2008
Qi Zhong
4 out of 4 found this review helpful
I started working for a hedge fund when I brought this book because I don't know how to use VBA, and impressed my colleages with my rapid improvement in VBA programming. It helps a lot and have a lot of good tricks. Will be very useful if you know some level of programming.
Showing reviews 1-5 of 8
|
|
|
|
