Excel 2007 VBA Programmer's Reference 1st Edition

I have the second edition as well and all I can say is that these are great books. I wish the authors would write an updated version.

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.

I book this WROX book sight unseen, but after having read these reviews and owning many other WROX books. The immediate trigger for buying was having some of my Excel 2003 macros stop working in Excel 2007 due to the change in color scheme. This book is silent on the new color scheme. On the other hand, "Excel 2007 Power Programming with VBA (Mr. Spreadsheet's Bookshelf)" deals with this issue in depth, so I bought this reference also, and would recommend it over the WROX book. Mr Spreadsheet's book has saved my bacon.The WROX book doesn't handle the translation of Excel 2003 "lists" to Excel 2007 "tables" completely. I would have liked more info on Structured References, which have the potential to make "tables" actually useful.

I haven't written basic since junior high, so I was pretty rusty. I know the basics with Excel, and C coding, so this was a very helpful resource to understand how the macros work. Chapter 1 gave me a big picture view, and the index has been helpful for understanding various details.

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.

Excellent source...This whole series of books just fit with my style of learning and working. Lots of great info in this written in a way that doesn't waste your time, but also doesn't leave too much out.

You try to code, you lurk forums, you Google it, and then you fall back on this book. This is the bible you should have available anytime you're coding. Stop reading this. Just get it!

I found the introductory chapters and concepts were laid out more logically, and explained more thoroughly than the other VBA 2007 references I've read. For someone like me who is just starting out on the VBA journey, it was far easier to comprehend compared to John Walkenbach's VBA reference. Excellent use of examples also.

A lot of the old Wrox books are just a print out whats available in Help. It's tiring reading the same thing in different books, there is a lot of filler in the old Wrox books. Luckily there is no history lesson spanning the first chapter or two, but you do get to learn what a loop is and what If statement is (seriously..?!). Yes it is a reference, but some of the information isn't made easy to find and there are mentions of bits which retain compatibility with Excel 95 / 97, which shows the books age. Also luckily I have the Kindle version so my shelves do not break under the shear weight of old wrox books. I probably regret buying it but I have it now so its just there, in the ether to read. Could probably get the same information for free online or in other books which are better organised and easier to read. Gets a bit more interesting from Chapter 16, which is about 1/3 of the way in though. but it does refer to making addins with Visual Basic 6..oh dear. The last 40% of the book is taken up detailing in excruciating details the Excel object model, the VBE object model and a completely meaningless index (as it has no page numbers..).

Its hard to know where to place this book, it has pretensions of being an advanced reference book but really its best suited to the middle ground between beginner and intermediate. The main problem with it is that although its a huge book there is actually not that much in it, nearly 50% of the bulk is padded out pointlessly with the object model.. which is available from the excel help files and the MSDN anyway. The rest although good is little more than an introduction and taster of each subject.Its hard to say who I can recommend this book too... the beginner will find the VBA introduction insufficient and the core topics such as the pivot tables, range object, worksheet and workbook objects just not covered in enough detail... the intermediate will find that the more advanced topics such as automation and connections etc really have no detail at all.So for the beginner who has graduated from a good foundation book, such as Steven Roman's O'Reilly "Writing excel Macros", this may serve to introduce the more advanced topics and someone in that situation may find this book very illuminating without being too impenetrable... however I find I use it much less than I expect, 9 times out of 10 when I look something up it gives me the very basics but then I have to go away and look up useful detail elsewhere...

Whilst at times it can be very long-winded there is no doubt here that the author's know their stuff. Unlike many technical books, there are many helpful examples to accompany the detail- which yes the authors do loose themselves in from time to time. Overall though an outstanding book for reference...just not one for reading front to back as it does go on! One last important point. The download files will NOT open in Excel 2010 as they are all in Excel 2007 BETA format.

This is a superb book aimed at people with a modicum of programming experience - I am not a computer programmer but have dabbled in the past and this book suited me very well, in covering all possibly VBA for Excel aspects and giving example short programmes which I could copy/modfiy to suit my problem.

Works fine, quality product. would recommend it .. .. .. .. .. . .. .. .. .. . . .