Mastering VBA for Microsoft Office 2016, 3rd Edition
By Richard Mansfield
Publisher: Wiley / Sybex
Final Release Date: February 2016
Pages: 984

Customize Office Applications Even Without Programming Experience

Streamline tasks and be far more productive by using Visual Basic for Applications (VBA) to automate, customize, and extend Microsoft Office. Built into Office 2016, VBA is easily understood by even non-programmers, yet it's also powerful enough for IT professionals to create custom business applications for the enterprise. This clear, comprehensive guide covers it all—the basics for beginners and advanced techniques for experienced programmers.

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 2016
  • Working with the powerful VBA Editor
  • Mastering the essentials of VBA terminology
  • Finding the objects, methods, and properties you need
  • Making the most of the huge library of built-in functions
  • Creating simple dialog boxes and complex forms
  • Writing well-behaved, debugged, and secure code
  • Managing cloud storage with OneDrive and Dropbox
  • Customizing Word, Excel®, PowerPoint® , Outlook®, and Access®
  • Communicating between applications
  • Programming the Office 2016 ribbon

Streamline and Automate Tasks with VBA for Office 2016

Create Custom Apps for Word, Excel, PowerPoint, Outlook, and Access

Master VBA, from Basic to Advanced Programming

Build Your Skills with Useful Real-World Examples and Projects

Product Details
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyMastering VBA for Microsoft Office 2016, 3rd Edition
 
5.0

(based on 1 review)

Ratings Distribution

  • 5 Stars

     

    (1)

  • 4 Stars

     

    (0)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

Reviewed by 1 customer

Displaying review 1

Back to top

 
5.0

PowerPoint mail merge extension using vba

By Dl

from Ca

About Me Developer

Verified Buyer

Pros

  • Accurate
  • Concise
  • Easy to understand
  • Helpful examples
  • Well-written

Cons

    Best Uses

    • Intermediate

    Comments about oreilly Mastering VBA for Microsoft Office 2016, 3rd Edition:

    I'm using Excel and PowerPoint and an add-in for PowerPoint called PPTools to do Mail Merge for slides. These tools generate ppt files. With the help this book I was able to develop an extension to the add-in that generates PDF files.

    I started with zero vba experience and the book helped me understand the vba development environment as well as vba coding.

    Displaying review 1

    Back to top

     
    Buy 2 Get 1 Free Free Shipping Guarantee
    Buying Options
    Immediate Access - Go Digital what's this?
    Ebook:  $50.00
    Formats:  ePub, Mobi, PDF