ebookshare.net

Mastering VBA for Microsoft Office 2007 (c) by Sybex

The type of the release is: eBook
In the PDF format with ISBN: 0470279591 and Pub Date: April 28, 2008
The size of the release is: 03 disks x 2.88mb
And released on: 08/02/2008


Get more done in less time by automating Office tasks Even 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(r) for Applications (VBA) and the in-depth instruction in this
comprehensive guide. You'll jump right into the basics of recording and
running macros with Office's built-in Macro Recorder, before quickly
moving to the essentials of VBA syntax, using loops and functions,
building effective code, and programming applications in Word, Excel(r),
PowerPoint(r), Outlook(r), and Access(r). You'll find pages of
real-world examples as well as easy-to-follow techniques for topics such
as accessing one application from another, 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 If statements
for flexibility
*

Adding more choices with message, input, and dynamic dialog boxes
*

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

http://www.amazon.com/exec/obidos/tg/detail/-/0470279591/