April, 2007
Page 142

Resources

Books, References, and Tools discussed in Moving from MS Office VBA to AppleScript

The below links are useful resources for anyone doing AppleScript. There are also a variety of links specific to AppleScripting Microsoft Office.

Script Editors

Script Editor
<http://www.apple.com/applescript/scripteditor/>

Script Debugger
<http://www.latenightsw.com/sd4/download.html>

Smile
<http://www.satimage.fr/software/en/downloads_software.html>

AppleScript Studio (with Xcode)
<http://www.apple.com/applescript/studio/>

Books on AppleScript

AppleScript: The Definitive Guide, 2^nd Edition by Matt Neuburg (O‘Reilly)
<http://www.oreilly.com/catalog/applescpttdg2/>

AppleScript: The Missing Manual by Adam Goldstein (O‘Reilly)
<http://www.oreilly.com/catalog/applescripttmm/>

AppleScript: The Comprehensive Guide to Scripting and Automation in Mac OS X, 2^nd Edition by Hanaan Rosenthal (Apress)
<http://www.apress.com/book/bookDisplay.html?bID=10107>

Beginning AppleScript by Stephen G. Kochan (Wrox)
<http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764574000.html>

Danny Goodman‘s AppleScript Handbook, Mac OS X Edition by Danny Goodman (SpiderWorks)
<http://www.spiderworks.com/books/ashandbook.php>

Mac OS X Technology Guide to Automator by Ben Waldie (SpiderWorks)
<http://www.spiderworks.com/books/automator.php>

MacTech Magazine

MacTech Article Archives:
<http://www.mactech.com/articles/>

MacTech.com Site Search, MacTech Community Search:
<http://www.mactech.com/search/advancedsearch.html>

Microsoft Office AppleScript Reference Guides

AppleScript Reference Guides for Word, Excel and PowerPoint
<http://www.microsoft.com/mac/resources/resources.aspx?pid=asforoffice>

Office 2004 for Macintosh: The Missing Manual Chapter 22: AppleScript by Paul Berkowitz (O‘Reilly)
<http://www.oreilly.com/catalog/officemactmm/>

Mailing Lists and Newsgroups

AppleScript-Users Mailing List
<http://lists.apple.com/mailman/listinfo/applescript-users>

Microsoft Mac Office Newsgroups
<http://www.microsoft.com/mac/community/community.aspx?pid=community>

Or in a news reader (e.g. Entourage) at Microsoft News Server: msnews.microsoft.com
microsoft.public.mac.office
microsoft.public.mac.office.entourage
microsoft.public.mac.office.excel
microsoft.public.mac.office.powerpoint
microsoft.public.mac.office.word

Replacements for User Forms and Toolbars

AppleScript Studio
<http://developer.apple.com/documentation/AppleScript/Conceptual/StudioBuildingApps/>
<http://developer.apple.com/documentation/AppleScript/Reference/StudioReference/>

FaceSpan

<http://www.latenightsw.com/fs4/index.html>

Smile
<http://www.satimage.fr/software/en/downloads_software.html>

24U Appearance OSAX
<http://www.24usoftware.com/AppearanceOSAX>

Pashua
<http://www.bluem.net/downloads/pashua_en/>

REALbasic
<http://www.realsoftware.com/>

Scripts for Entourage and Office Applications

ScriptBuilders at Macsripter.net
<http://scriptbuilders.net/>

Other Relevant Software For AppleScripters

AppleScript
<http://developer.apple.com/applescript/>

Apple‘s Automator and Developer Tools (Xcode)
<http://www.apple.com/automator/>
<http://www.apple.com/macosx/developertools/>
<http://automator.us>
<http://www.automatorworld.com>
<http://www.automatoractions.com>

DragThing
<http://www.dragthing.com/>

iKey
<http://www.scriptsoftware.com/ikey/>

PreFab UI Browser
<http://prefabsoftware.com/>

QuicKeys
<http://www.quickeys.com/>

Version Tracker
<http://www.versiontracker.com>

Other Resources for Microsoft Office

Mac Word MVP WebSite
<http://word.mvps.org/Mac/WordMacHome.html>

Word MVP WebSite
<http://word.mvps.org/index.html>

Entourage MVP WebSite
<http://www.entourage.mvps.org/index.html>

Microsoft MacTopia Website
<http://www.microsoft.com/mac/>

Acknowledgements

This document was written by Paul Berkowitz. You can find many of Paul‘s scripts at:
       <http://scriptbuilders.net/search.php?search_str=Paul%20Berkowitz>

The "punch list" team, who provided all the VBA macros, and some descriptive text as well. This project could not have been created without them: