Moving from Microsoft Office VBA to AppleScript:
MacTech's Guide to Making the Transition

Page Prev and Page Next buttons at bottom of the page.

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: