My 8 chapter Mac Automation Made Simple video series is 35% off through the end of the year if you use coupon code VIDEO12.
[Learn more here or visit the Peachpit website]
Just another WordPress site
My 8 chapter Mac Automation Made Simple video series is 35% off through the end of the year if you use coupon code VIDEO12.
[Learn more here or visit the Peachpit website]
Peachpit has bundled a new series of my Mac Automation Made Simple videos on Automator. They're now available for purchase as DRM-Free downloads, so you can play them on your Mac, iPhone, or iPad. Topics in this 8-part series include:
Sold as a set, or individually, you can find them on Peachpit's website.
Episode 10
Date: 11.25.2008
Duration: 00:07:17
Creating a Microsoft Excel 2008 Automator Workflow
In this episode of Mac Automation Made Simple, Ben Waldie demonstrates how to use Automator to perform tasks in Microsoft Excel 2008. Ben shows you a workflow to batch convert Excel workbooks to .csv format and one that builds address labels in Excel.
[View in Tunes...] [View at Peachpit.com...]
04.30.08 - Creating a Microsoft Excel 2008 Automator Workflow.
Today’s Office 2008 Automator workflow is for Excel. This workflow will retrieve a list of selected tracks in iTunes. It will then create a formatted and sorted list of the names of those tracks in a new Excel workbook and save that workbook in HTML format. You could then incorporate the HTML into your Web site to display a list of your favorite iTunes tracks. [Read more at Peachpit.com...]
Macworld 2008 - A Day at the Office Series
Office 2008 and Automator: Creating Office workflows with Automator
[Watch now...]
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.com...]
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 MacTech.com...]
Copyright © 2023 · Automated Workflows