Mastering VBA for Office 2010
- ISBN-10
- 0470634006
- ISBN-13
- 9780470634004
- Category
- Computers
- Pages
- 912
- Language
- English
- Published
- 2010-08-24
- Publisher
- John Wiley & Sons
- Author
- Richard Mansfield
Description
A comprehensive guide to the language used to customize Microsoft Office Visual Basic for Applications (VBA) is the language used for writing macros, automating Office applications, and creating custom applications in Word, Excel, PowerPoint, Outlook, and Access. This complete guide shows both IT professionals and novice developers how to master VBA in order to customize the entire Office suite for specific business needs. Office 2010 is the leading productivity suite, and the VBA language enables customizations of all the Office programs; this complete guide gives both novice and experienced programmers the knowledge they need to make maximum use of VBA for Office Supported with real-world examples in Word, Excel, PowerPoint, Outlook, and Access, this book offers clear, systematic tutorials with both intermediate and advanced content Covers learning how to work with VBA; recording macros; 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 Mastering VBA for Office 2010 prepares developers to customize all Microsoft Office 2010 applications for the unique needs of their employers.
Get the book
Other editions
Similar books
-
Office 2010 Library: Excel 2010 Bible, Access 2010 Bible, PowerPoint 2010 Bible, Word 2010 Bible
By Faithe Wempen, John Walkenbach, Michael R. GrohTap all the tools in PowerPoint's formidable toolkit and connect with your audience. This guide shows you how to get the very most out of everything the exciting PowerPoint 2010 has to offer. Here's the first and last word on Word!
-
Microsoft Visual Basic 2010 Step by Step
By Michael HalvorsonYour hands-on, step-by-step guide to learning Visual Basic 2010.
-
Mastering VBA for Microsoft Office 365
By Richard MansfieldThis 2019 Edition of Mastering VBA for Microsoft Office 365 and Office 2019 features clear, step-by-step tutorials to show both inexperienced and veteran programmers how to customize and automate each of the major Office 365 applications: ...
-
VBA and Macros: Microsoft Excel 2010
By Bill Jelen, Tracy Syrstad294 using Advanced Pivot table Features .......... 302 tools of choice for many different uses. You can build pivot tables to act as the calculation engine to produce reports by store, by style, or to quickly find Filtering a data Set .
-
Mastering VBA for Microsoft Office 2007
By Richard MansfieldEven if you're not a programmer, you can quickly learn to write macros, automate tasks, and create custom applications for Office 2007 with Microsoft'sVisual Basic for Applications (VBA) and the in-depth instruction in this comprehensive ...
-
Excel 2010 Power Programming with VBA
By John WalkenbachJohn Walkenbach, aka Mr. Spreadsheet, shows you how to do it in this easy-to-follow guide. If you're already an experienced Excel user, this book will make you an Excel master.
-
Microsoft Access 2010 VBA Programming Inside Out
By Andrew CouchYou're beyond the basics, so dive right in and customize, automate, and extend Access—using Visual Basic for Applications (VBA).
-
Excel 2013 VBA and Macros
By Bill Jelen, Tracy SyrstadThis book provides information on ways to automate routine tasks with Excel and build Excel macros.
-
Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET
By Rob BoveyA guide to the development aspects of Excel covers such topics as building add-ins, creating custom charts, using class modules, handling errors, controlling external applications, and programming with databases.
-
Excel VBA 365 Made Easy
By Dr.Liew Voon KiongBy the end of this book, you will gain a comprehensive understanding of basic Excel VBA 365 concepts and be able to create your own code from scratch. You will learn how to: 1.