A unique, comprehensive guide to creating custom apps withVBA
Automating computing tasks to increase productivity is a goalfor businesses of all sizes. Visual Basic for Applications (VBA) isa version of Visual Basic designed to be easily understandable fornovice programmers, but still powerful enough for IT professionalswho need to create specialized business applications. With thisinvaluable book, you'll learn how to extend the capabilities ofOffice 2013 applications with VBA programming and use it forwriting macros, automating Office applications, and creating customapplications in Word, Excel, PowerPoint, Outlook, and Access.
- Covers the basics of VBA in clear, systematic tutorials andincludes intermediate and advanced content for experienced VBdevelopers
- Explores recording macros and getting started with VBA;learning how to work with VBA; using loops and functions; usingmessage boxes, input boxes, and dialog boxes; creating effectivecode; XML-based files, ActiveX, the developer tab, contentcontrols, add-ins, embedded macros, and security
- Anchors the content with solid, real-world projects in Word,Excel, Outlook, PowerPoint, and Access
Covering VBA for the entire suite of Office 2013 applications,Mastering VBA for Microsoft Office 2013 is mandatoryreading.
Make Office Your Own with VBA
Customize Office, streamline tasks, and be far more productiveby leveraging Visual Basic for Applications (VBA) to automate andextend Microsoft Office. VBA is built into Office 2013 applicationsand is easily understood even by non-programmers. It is powerfulenough for IT professionals to create custom business applicationsfor the enterprise. This detailed book covers it all—thebasics for beginners and advanced content for experienced VBdevelopers. You'll learn how to use VBA to create macros, simplifyOffice 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 Office2013
Create Custom Apps for Word, Excel, PowerPoint, Outlook, andAccess
Master the Information You Need, from Basic toAdvanced
Enhance Your Skills with Real-World Examples andProjects