- Paperback: 960 pages
- Publisher: Sybex; 2 edition (August 26, 2013)
- Language: English
- ISBN-10: 1118695127
- ISBN-13: 978-1118695128
- Product Dimensions: 7.3 x 2 x 9.2 inches
- Shipping Weight: 3.1 pounds (View shipping rates and policies)
- Average Customer Review: 23 customer reviews
- Amazon Best Sellers Rank: #264,842 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 2013 2nd Edition
Use the Amazon App to scan ISBNs and compare prices.
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
Frequently bought together
Customers who bought this item also bought
From the Back Cover
Make Office Your Own with VBA
Customize Office, streamline tasks, and be far more productive by leveraging Visual Basic for Applications (VBA) to automate and extend Microsoft Office. VBA is built into Office 2013 applications and is easily understood even by non-programmers. It is powerful enough for IT professionals to create custom business applications for the enterprise. This detailed book covers it allthe basics for beginners and advanced content for experienced VB developers. You'll learn how to use VBA to create macros, simplify Office tasks, and create custom solutions for Word, Excel, PowerPoint, Outlook, and Access.
- Recording, writing, and running macros in Office 2013
- Tapping into the power of the VBA Editor
- Understanding the essentials of VBA terminology
- Finding the objects, methods, and properties you need
- Using built-in functions and creating your own
- Creating simple dialog boxes and complex forms
- Writing well-behaved, debugged, and secure code
- Managing cloud storage with SkyDrive and Dropbox
- Customizing Word, Excel®, PowerPoint®, Outlook®, and Access®
- Accessing one application from another
- Programming the Office 2013 ribbon
Streamline and Automate Tasks with VBA for Office 2013
Create Custom Apps for Word, Excel, PowerPoint, Outlook, and Access
Master the Information You Need, from Basic to Advanced
Enhance Your Skills with Real-World Examples and Projects
About the Author
Richard Mansfield is the author or coauthor of 45 books, including Visual Basic 6 Database Programming For Dummies, Office 2003 Application Development All-in-One Desk Reference For Dummies, How to Do Everything with Second Life, and Programming: A Beginner's Guide. He is the former editor of Compute! magazine. Overall, his books have sold more than half a million copies worldwide and have been translated into 12 languages.
Top customer reviews
Even with the experience I'd gained, I started at the very beginning of the book (skipping the exercises/practice when I knew that I knew how to do them) and worked through it chapter by chapter. I have had to skip ahead now and then to complete specific assignments at work, but skipping didn't leave me confused, as there are plenty of references to earlier material when needed.
My only complaint is the editing between the sample code and the text. Sometimes, the text refers to something in the sample code, but the code doesn't match what the text says it is. (For example, Listing 3.4 on page 77, and the steps that follow it don't match up completely.) I'm a technical editor who is branching out into VBA, so it's clear this is an artifact of revising the earlier edition, and no important information is lost. This also might not bother someone who isn't an editor by trade.
When purchasing a tech book, I like to flip it open to the half-way point to see how complicated it is. If that chapter is something I think I could learn from (instead of author myself), then I know the book is going to be worth the money for me. I flipped this book open half-way and found a chapter on Creating and Using Classes. This is, in my opinion, an advanced topic. In 16 years, I've used other developers' classes and on a couple of occasions, built my own. But I realized immediately that this was a chapter I wanted to read.
Further on in the book were the topics I was really looking for: Office Automation. I'm pretty strong with Excel and Outlook, but I really needed a reference for automating Word in VBA. I'm just getting started in that section, but it looks like it's just what I needed. The section on Excel looks good too and when I'm done with this book, my workmate said he wants to read the Excel chapters.
One last thing I always look for is a good explanation of debugging. In specific, I look to see if the author mentions the "Immediate Window". As a developer, this is where I spend about 1/4 of my time, checking code as it runs, verifying syntax and manipulating the application using commands. Not only does the author mention the "Immediate Window", he also revealed the Ctl+G keystroke combo to open it. I don't know this author personally but that alone impressed me with regard to his credentials. It's a dumb thing, I know, but having read a LOT of tech books, I've got a feel for what to look for, what shows the author is worth reading. So while I'm not done with the book yet, I can still give it a thumbs up. I'm glad I got it.