- Paperback: 888 pages
- Publisher: Sybex; 2 edition (April 28, 2008)
- Language: English
- ISBN-10: 0470279591
- ISBN-13: 978-0470279595
- Product Dimensions: 7.4 x 1.8 x 9.3 inches
- Shipping Weight: 2.8 pounds
- Average Customer Review: 20 customer reviews
- Amazon Best Sellers Rank: #546,076 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Mastering VBA for Microsoft Office 2007 2nd Edition
Use the Amazon App to scan ISBNs and compare prices.
Fulfillment by Amazon (FBA) is a service we offer sellers that lets them store their products in Amazon's fulfillment centers, and we directly pack, ship, and provide customer service for these products. Something we hope you'll especially enjoy: FBA items qualify for FREE Shipping and Amazon Prime.
If you're a seller, Fulfillment by Amazon can help you increase your sales. We invite you to learn more about Fulfillment by Amazon .
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
Customers who bought this item also bought
From the Back Cover
Get more done in less time by automating Office tasks
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®. You'll find pages of real-world examples as well as easy-to-follow techniques for topics such as accessing one application from another, programming the Ribbon, and much more.
Understanding the essentials of VBA syntax
Using the Macro Recorder in Word and Excel
Creating code from scratch with the Visual Basic Editor
Finding the objects, methods, and properties you need
Using loops to repeat actions in your code and adding If statements for flexibility
Adding more choices with message, input, and dynamic dialog boxes
Modifying the Ribbon with XML code and callbacks
Building, debugging, and securing your code
Use VBA to Customize Your Office 2007 Applications
Transform Complex Operations into a Single Keystroke
Work with XML-based Files, the Ribbon, and ActiveX
Add Embedded Macros and Add-ins to Improve Productivity
Reinforce Your Skills with Real-World
About the Author
Richard Mansfield is the author of more than 40 computer books, including CSS Web Design For Dummies (Wiley), Office 2003 Application Development All-in-One Desk Reference For Dummies (Wiley), Visual Basic .NET Power Tools (Sybex), and others. He is the former editor of COMPUTE! magazine and has written hundreds of magazine articles and two long-running columns.
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
Because I am a novice, after reading reviews on several books, I decided to order two: this one by Mansfield and 'Mastering VBA' by Hart-Davis. After receiving and reviewing them, I was very surprised to learn that they are essentially the same book! They have the same publisher, and in fact the same Production Editor.
The Mansfield book is over 100 pages longer. Many of the Mansfield chapters contain more topics, plus there is an extra chapter (31). I did not do an exact word for word match on all the chapters, but from the ones I looked at, it appears that over 95% of the words in the Hart-Davis book are identical to the words in the Mansfield book. Also, the Mansfield book allows you to download ALL of the code examples used in the book, so you don't have to type in the code manually. The website for this code is on the 1st page of the Introduction. Although this book was published 6 years ago, the website link still works (go to the middle of the website page, under 'Downloads').
So if you are interested in one of these two used books, buy the Mansfield one.
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!
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.
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.