Mastering VBA for Microsoft Office 2013 - Brossura

Mansfield, Richard

Brossura

ISBN 10: 1118695127 ISBN 13: 9781118695128

Casa editrice: Sybex Inc, 2013

Riassunto

A unique, comprehensive guide to creating custom apps with VBA

Automating computing tasks to increase productivity is a goal for businesses of all sizes. Visual Basic for Applications (VBA) is a version of Visual Basic designed to be easily understandable for novice programmers, but still powerful enough for IT professionals who need to create specialized business applications. With this invaluable book, you'll learn how to extend the capabilities of Office 2013 applications with VBA programming and use it for writing macros, automating Office applications, and creating custom applications in Word, Excel, PowerPoint, Outlook, and Access.

• Covers the basics of VBA in clear, systematic tutorials and includes intermediate and advanced content for experienced VB developers
• Explores recording macros and getting started with VBA; learning how to work with VBA; using loops and functions; using message boxes, input boxes, and dialog boxes; creating effective code; XML-based files, ActiveX, the developer tab, content controls, 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 mandatory reading.

Su questo libro

Informazioni sull?autore

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.

Dalla quarta di copertina

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

Dettagli dell'edizione

• Editore: Sybex Inc
• Data di pubblicazione: 2013
• Lingua: Inglese
• ISBN 10: 1118695127
• ISBN 13: 9781118695128
• Rilegatura: Copertina flessibile
• Numero di pagine: 924
• Contatto del produttore: non disponibile
• Persona responsabile: non disponibile