Mastering VBA for Microsoft Office 2007 (Mastering)

Even if you're not a programmer, you can quickly learn to write macros, automate tasks, and create custom applications for Office 2007 with Microsoft'sVisual Basic for Applications (VBA) and the in-depth instruction in this comprehensive guide. You'll jump right into the basics of recording and running macros with Office's built-in Macro Recorder, before quickly moving to the essentials of VBA syntax, using loops and functions, building effective code, and programming applications in Word, Excel, PowerPoint, Outlook, and Access. Includes pages of real-world examples and techniques.

User review
The Best VBA Book
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!

User review
Mastering VBA for Microsoft Office 2007
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.

User review
Mastering VBA - good review
I was looking for specific information and this book provided it. I had been dealing with a VBA 2003 book that did not match the Office 2007 architecture. I have not had much spare time, so I wanted something direct but not too technical.

User review
Haven't been able to use it much, yet;,,.
I have found the book very easy to understand where I have been able to use it. I enjoy the on-line information available.


User review
A useful 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.