Peachpit Blog Post > Getting to know Microsoft Office 2008’s Automator support

04.28.08 - Getting to know Microsoft Office 2008's Automator support.

Mac users are probably aware that Microsoft released a new version of Office back in January. The new Office 2008 includes loads of new features and options, including more than 90 Automator actions (which I actually developed under contract) for Entourage, Excel, PowerPoint, and Word. Using these actions, you can now integrate your Office applications together—as well as other applications such as iCal, iTunes, iPhoto, and Safari—to create simple automated workflows. Throughout this week, I will be discussing the Office 2008 Automator actions and giving you some examples of things that can be done with them. [Read more at]

Macworld 2008 Presentation > Office 2008 and Automator

Macworld 2008 - A Day at the Office Series
Office 2008 and Automator: Creating Office workflows with Automator
[Watch now...]

MacTech AppleScript Essentials Column > Introduction to Scripting Microsoft Entourage

May, 2007 - Introduction to Scripting Microsoft Entourage.

For some time now, we have been discussing scripting the Microsoft Office applications, partially in preparation for the forthcoming release of Office 2008, in which Microsoft has announced that Visual Basic macros will no longer be supported. So far, we have explored the AppleScript support in Microsoft Word, Excel, and PowerPoint, three applications that currently (in Office 2004) include Visual Basic macro support. This month, we are going to discuss the fourth major Office application, Entourage, a popular email and project management client. [Read more at]

MacTech AppleScript Essentials Column > Introduction to Scripting Microsoft PowerPoint

March, 2007 - Introduction to Scripting Microsoft PowerPoint.

In recent months, we have been discussing ways to automate the Office applications using AppleScript. We have discussed Word and Excel scripting, and this month, we are going to focus on scripting PowerPoint. [Read more at]

MacTech AppleScript Essentials Column > Introduction to Scripting Microsoft Excel

February, 2007 - Introduction to Scripting Microsoft Excel.

With Office 2008 on the horizon, Microsoft has recently begun to push AppleScript as an alternative automation technology to Visual Basic macros in the Office applications. Moving forward, Visual Basic macros will not be supported in the release of Office 2008. Current AppleScript users are ahead of the curve. The Office applications have been AppleScriptable for quite some time, and AppleScript actually provides several advantages over Visual Basic. For one, AppleScripts can interact with multiple applications, including non-Microsoft applications, allowing even complex multi-application workflows to be automated.

Last month, we began discussing how to get started with scripting Microsoft Word. We explored various techniques for interacting with Word documents, as well as the content within those documents, all using AppleScript. This month, we're going to begin discussing another Office application, Microsoft Excel. Like Word, Excel contains a quite extensive AppleScript dictionary, allowing almost any task that can be performed manually to be automated using AppleScript. [Read more at]