All of the content in these topics was adapted from "Moving from Microsoft Office VBA to AppleScript: MacTech's Guide to Making the Transition," written by Paul Berkowitz, and originally published in MacTech Magazine, April 2007, on pages 73–215. You can find many of Mr. Berkowitz's scripts on the search results page for Paul Berkowitz
(http://scriptbuilders.net/search.php?search_str=Paul%20Berkowitz)
on the MacScripter Web site.
About the author
Paul Berkowitz is an expert on both AppleScript and Microsoft Office 2004 for Mac. He wrote the chapter on AppleScript in Office 2004 for Macintosh: The Missing Manual, written by Mark Holt Walker, Franklin Tessler, and Paul Berkowitz, and published by Pogue Press. He was the technical editor for several books on AppleScript, including AppleScript: The Definitive Guide, 1st Edition, written by Matt Neuburg, and published by O'Reilly Media, Inc.; and AppleScript: The Missing Manual, written by Adam Goldstein, and published by O'Reilly Media, Inc.
Mr. Berkowitz is well known for writing and publishing more than 100 AppleScripts for Microsoft Entourage, especially those that export and import almost all Entourage
data, and sync Entourage
to the Apple
Address Book and iCal. He is one of the Microsoft Most Valuable Professionals (MVPs)
(www.microsoft.com/mac)
for Office for Mac, helping out users in Microsoft
newsgroups, and writing the article on using the do Visual Basic command.
He also has a completely separate life as a classical concert pianist and Professor of Piano.
Contributors
Mr. Berkowitz credits the "punch list" team in the table below for providing all the Visual Basic for Applications (VBA) macros and some descriptive text as well. This project could not have been created without them.
Contributor | Web site |
|---|---|
Jonathan West, Technical Director, The Intelligent Document Company; Word MVP | The Intelligent Document Company |
Bill Coan, Word MVP | Wordsite |
Ibrahim (Ibby) Elnazak, Word MVP | The Ibrahim (Ibby) Elnazak page |
Dave Rado, Word MVP | The Dave Rado page |
John McGimpsey, McGimpsey & Associates; Mac Word (Excel) MVP | J.E. McGimpsey's XL Pages |
Steve Rindsberg, PPTTools; PowerPoint MVP |
|
Barry Wainwright, Entourage MVP | Barry Wainwright's My Applescripts page |
Erik Schwiebert, Microsoft Office for Mac Development Lead | Erik Schwiebert's blog |
Web sites
Mr. Berkowitz used Word
macros from the Microsoft Word MVP FAQ Site
(http://www.word.mvps.org/FAQs/MacrosVBA/)
in his article.


