Mastering VBA for Microsoft Office 2007, 2nd Edition
By Richard Mansfield
Publisher: Wiley / Sybex
Final Release Date: July 2008
Pages: 864

Get more done in less time by automating Office tasks

Even if you're not a programmer, you can quickly learn to writemacros, automate tasks, and create custom applications for Office2007 with Microsoft'sVisual Basic® for Applications (VBA) andthe in-depth instruction in this comprehensive guide.

You'll jump right into the basics of recording and runningmacros with Office's built-in Macro Recorder, before quickly movingto the essentials of VBA syntax, using loops and functions,building effective code, and programming applications in Word,Excel®, PowerPoint®, Outlook®, and Access®.You'll find pages of real-world examples as well as easy-to-followtechniques for topics such as accessing one application fromanother, programming the Ribbon, and much more.

Coverage includes:

  • Understanding the essentials of VBA syntax

  • Using the Macro Recorder in Word and Excel

  • Creating code from scratch with the Visual Basic Editor

  • Finding the objects, methods, and properties you need

  • Using loops to repeat actions in your code and adding Ifstatements for flexibility

  • Adding more choices with message, input, and dynamic dialogboxes

  • Modifying the Ribbon with XML code and callbacks

  • Building, debugging, and securing your code

  • Use VBA to Customize Your Office 2007 Applications

  • Transform Complex Operations into a Single Keystroke

  • Work with XML-based Files, the Ribbon, and ActiveX

  • Add Embedded Macros and Add-ins to Improve Productivity

  • Reinforce Your Skills with Real-World

  • Examples

Product Details
Recommended for You
Customer Reviews
 
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook: $49.99
Formats:  ePub, Mobi, PDF