Customer Reviews

Mastering VBA for Microsoft Office 2007

5 star:		(8)
4 star:		(5)
3 star:		(0)
2 star:		(1)
1 star:		(1)

 

 

I have bought two other VBA books before this one. I am very happy with this book and will say this is the best VBA book out there. The book starts with the VBA environment. How the components (modules, projects, subclass, etc) constitue to the whole programming environment and relate to the office environment.Then it gives you the concept of object oriented programming. Then how this concept determines the coding syntax and how it interacts with the 'objects' from the office software. Then it goes into detail of how to write codes base on the teaching from the prior chapters to work on the objects (spreadsheets, range, cells, tables, forms, graphics,...) which you want to achieve the results or perform functions/calculations on.

Unlike other books that skip the basics and jump straight into performing tricky codings to perform fancy result, this book first gives you a great foundation to fully comprehend the VBA environment. It is a very organized book, and very easy to follow. If you follow the structure of the book and write sample codes according to the book instructions, you will learn VBA very easily and quickly. I strongly recommand this book!

I have been away from programming for about 10 years so I feel like a beginner in many respects. I had a need to automate the creation of some templates that I use frequently, but needed some help. This book was a good source for that help. I was able to find all the information that I needed, but it occasionally did require some searching. In a few cases, the information was not where I expected, but it was there. Like Microsoft's online help, each topic would benefit from a short example of the use of a particular command, but this might just be an indication of how much I have forgotten.

A good first book for beginners. Not enough information on the MS Office application object models to be an actionable resource, though. Plan on doing a lot of on-the-spot research when you actually sit down to write your first few scripts. I went ahead and got a second, more advanced, shorter book which considers the specific types of programs I will be writing after completing this.

I have recommended or loaned out the book to everyone who has approached me about learning to write macros.

I've been waiting for a long time to finally invest in a solid resource for VBA code. I've "tinkered in the arts" of writing VBA for two years, and have been interested in further expanding my abilities.

I finally broke down and bought this book. Upon receipt (very quickly, thanks Amazon) I flipped to a random page and began reading. I learned a new trick pretty quick, and in the same page, found a typographical error referencing a line of code in an example that didn't actually exist.

Later, I was trying to learn how to write code that would use built-in code witin Excel to reference the last active row of a spreadsheet (instead of using a default "1 to 1000" line of code.) The only example that the book gave actually included a typo to a command prompt that doesn't exist in VBA. Furthermore, the example didn't help me accomplish what it was supposed to, and I eventually had to use the VBA editor's built-in help routines to solve my problem.

And that's where this book fails - it doesn't really teach you anything that you can't learn with the built-in help routines. It doesn't help give you shortcuts or teach you any "tricks" - it just tells you what commands exist and how to use them - which is exactly what the help routines do. All-in-all I consider this to not only be a wasted purchase, but a purchase that could potentially harm rookie VBA authors who don't have the initial experience that I started with.

Hi and thanks for your amazingly quick response to my order and the earlier than expected delivery. I also saved a few dollars in the process so I am very happy.

As for the book, I was looking for something to bridge the gap between VB and Office which was more specific about linking code to applications and I am extremely pleased with my selection. The content is brilliant and concise and the layout is well organised. The only minor draw back from my perspective, is the small font which I am just managing with as a slow reader although, in reality, if the font were larger, the book would be somewhat thicker (already close to 900 pages).

So overall, this has been an excellent choice for me and I am enjoying finally, being able to extract the power of VBA in my favourite Office applications.

Thanks.

This is a well written book, but for an experienced programmer who has to get an assignment job done in VB it's a little too basic and just scratches the surface of the libraries. I suppose that the online doc will fill in what's not listed here but I'm not sure yet.
This book is for people with little or no programming experience, it explains the need for loops and things like that
and does a very good job at that.
I'm still looking for a more detailed book.

I am not a programmer by any stretch, but I've enjoyed putzing around with VBA in Excel for a few years now. This is by far the best resource (that includes books as well as web sites) that I've found for explaining the fundamentals and for branching off into other MS Office applications. It's not too much of a stretch to say I've learned more in the few weeks that I've had this book that I learned from all other places combined in the past year.

I am a certified expert on Word 2002, and had neglected to learn VBA at the time that I was studying for the test. I missed only one question about VBA, but felt bad that I didn't know it. Now that Office 2007 came out, I want to go back to learn VBA. This Mastering book is excellent! It begins with Macros, explains VBA in fantastic detail, and has a final chapter on XML, too.

So far, I have studied four chapters. I found it to be very clear in explanations and examples. I will submit another review once I finish up to chapter 10. Can't wait to get further in the book; it has me hooked.

I have found the book very easy to understand where I have been able to use it. I enjoy the on-line information available.