Mastering VBA for Microsoft Office 2016 - Softcover

Mansfield, Richard

Softcover

ISBN 10: 1119225388 ISBN 13: 9781119225386

Publisher: Sybex, 2016

Synopsis

Enhance productivity in any Office application with zero programming experience

Mastering VBA for Microsoft Office 2016 helps you extend the capabilities of the entire Office suite using Visual Basic for Applications (VBA). Even if you have no programming experience , you'll be automating routine computing processes quickly using the simple, yet powerful VBA programming language. Clear, systematic tutorials walk beginners through the basics, while intermediate and advanced content guides more experienced users toward efficient solutions. This comprehensive guide starts at the beginning to get you acquainted with VBA so you can start recording macros right away. You'll then build upon that foundation to utilize the full capabilities of the language as you use loops and functions, message boxes, input boxes, and dialog boxes to design your own Office automation program. Add-ins, embedded macros, content controls, and more give you advanced tools to enhance productivity, and all instruction is backed by real-world practice projects in Word, Excel, Outlook, and PowerPoint.

Productivity is the name of the game, and automating certain computing tasks is an easy solution with significant impact for any business. This book shows you how, with step-by-step guidance and expert insight.

• Expand Office 2016 functionality with macros
• Learn how to work with VBA and the entire Office suite
• Create effective code, even with no programing experience
• Understand ActiveX, XML-based files, the developer tab, and more

VBA is designed to be understandable and accessible to beginners, but powerful enough to create specialized business applications. If you're ready to begin exploring the possibilities, Mastering VBA for Microsoft Office 2016 gets you started right away.

About this title

About the Author

Richard Mansfield is a best-selling author and a widely recognized expert on computer programming. He has authored or co-authored 46 books, including Programming: A Beginner's Guide, and the best-sellers Machine Language for Beginners, and The Visual Guide to Visual Basic. Overall, his books have sold more than half a million copies worldwide and have been translated into 12 languages.

From the Back Cover

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

From the Inside Flap

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

Edition details

• Publisher: Sybex
• Publication date: 2016
• ISBN 10: 1119225388
• ISBN 13: 9781119225386
• Binding: Paperback
• Language: English
• Edition number: 3
• Number of pages: 984