Mastering VBA for Microsoft Office 2013

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 all—the 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.

Coverage includes:

• 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