|  | Author: John Walkenbach Publisher: For Dummies
List Price: $49.99 Buy Used: $18.47 as of 11/22/2009 05:29 CST details You Save: $31.52 (63%)
New (38) Used (28) from $18.47
Seller: awesomebooksusa Rating: 43 reviews Sales Rank: 29743
Languages: English (Original Language), English (Unknown), English (Published) Media: Paperback Pages: 1056 Number Of Items: 1 Shipping Weight (lbs): 3.4 Dimensions (in): 9.2 x 7.3 x 2.4
ISBN: 0764540726 Dewey Decimal Number: 005.54 UPC: 785555869370 EAN: 9780764540721 ASIN: 0764540726
Publication Date: January 13, 2004 Availability: Usually ships in 1-2 business days Condition: SHIPPED SAME DAY FROM UNITED KINGDOM USING PRIORITY AIRMAIL, SUPER FAST SHIPPING - AVERAGE DELIVERY TIME 7-12 DAYS TO USA. ALL BOOKS IN GOOD OR BETTER CONDITION. VISIT OUR eSHOP FOR MORE GREAT BARGAINS.
|
| Customer Reviews:
Showing reviews 11-15 of 43
Excel 2003 PPVBA February 15, 2008 R. Thomas (NJ) Book was helpful in the setup of various 'maintenance' routines. It gave me a fresh look at the use of properties, allowing me to streamline the coding. Unfortunately, company directives have us converting the work to 'active server pages' with a SQL 2005 database server. Since the source data is Oracle, I have been working on DB to DB utilities.
It's one of the best Excel book I have. January 18, 2008 Italo Rolando Pezo Vargas (Lima, Peru) It's an excellent an useful book. Personally, It's helped me a lot. I recommend to read it, because it has many simple and difficult examples of macros, codes, programming's techniques and functions. Also it teachs about API of Windows . It'll definitely help to be a successful developer on Excel.
Bad reference, good intro December 8, 2007 Jas Bro (London) 3 out of 3 found this review helpful
This is the first book I read on the subject (I am proficient in other languages/platforms).
It is a decent introduction, and it gives you a good overview of various areas of Excel/VBA programming. There are plenty of code examples and lots of opportunities to get your hands dirty modifying and debugging them.
I was very disappointed by its poor structure and lack of rigour. Concepts are introduced by example in seemingly unrelated chapters, therefore scattering language features all over the place. This, combined with an utterly useless index, means that unless you get a digital copy of the book you will have a very hard time using this book as a reference.
Also, in my opinion, the author has not gone out much using other more sophisticated languages, and this lack of discipline/hacking attitude is often noticeable. Not only in the occasional sloppiness of his code (whoever proof-read this book did an awful job too by the way), but also in the poor explanation of higher features of VBA, for instance class modules, relegated to a 10-page chapter towards the end, whose examples are anyway missing the whole point of stateful encapsulation through class objects. Similarly poorly explained (many chapters earlier, incidentally) is the use of class objects for Application-level events, with the mysterious "With Events" qualifier which is never really explained anywhere.
I often found that the material lacked diagrams and more abstract and general explanations that go beyond the "learn by example" cookbook approach.
Finally, I was annoyed by the frequent, not-so-subliminal adverts to the author's software package, of which a trial is available on the CD.
Overall, it did the job for me - helping me getting to grips with the language and the object model. But if you are already beyond the basics get yourself a good reference, or perhaps Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft(R) Excel and VBA(R) (The Addison-Wesley Microsoft Technology Series), which I have already started reading with interest and seems to explain much more methodically best practices and more advanced concepts - while still not a VBA reference.
Excel 2003 Power Programming with VBA October 25, 2007 Nino Chelidze (ID, USA) 1 out of 1 found this review helpful
The book was brand new as said in the description. Had a CD which was nice to find certain things in the book easier. The book itself though has very easy examples, so if you plan to do complicated programming, you might want to consider something else (if there is anything better available).
More than just a VBA book October 17, 2007 J. Omohundro (Colorado) When I opened this book up, I was surprised to find much more than just VBA programming. In fact, you don't get much "VBA-Anything" until about page 130. There's all sorts of tips and tricks in the earlier pages, along with some good background of how Excel was developed and how it's supposed to function--stuff that will be valuable the more you get into coding with VBA.
This is not a book for a person just getting into Excel. I've taken two college-level courses in Excel, and I've played with spreadsheets for a number of years previous to that, so I'm somewhat comfortable with them. If I wasn't, this book would overwhelm and intimidate. So if you haven't worked with spreadsheets much, I would suggest getting some experience in just working with one before you tackle VBA.
Showing reviews 11-15 of 43
|
|
|