• MacTech Network:
  • Tech Support
  • |
  • MacForge.net
  • |
  • Apple News
  • |
  • Register Domains
  • |
  • SSL Certificates
  • |
  • iPod Deals
  • |
  • Mac Deals
  • |
  • Mac Book Shelf

MAC TECH

  • Home
  • Magazine
    • About MacTech in Print
    • Issue Table of Contents
    • Subscribe
    • Risk Free Sample
    • Back Issues
    • MacTech DVD
  • Archives
    • MacTech Print Archives
    • MacMod
    • MacTutor
    • FrameWorks
    • develop
  • Forums
  • News
    • MacTech News
    • MacTech Blog
    • MacTech Reviews and KoolTools
    • Whitepapers, Screencasts, Videos and Books
    • News Scanner
    • Rumors Scanner
    • Documentation Scanner
    • Submit News or PR
    • MacTech News List
  • Store
  • Apple Expo
    • by Category
    • by Company
    • by Product
  • Job Board
  • Editorial
    • Submit News or PR
    • Writer's Kit
    • Editorial Staff
    • Editorial Calendar
  • Advertising
    • Benefits of MacTech
    • Mechanicals and Submission
    • Dates and Deadlines
    • Submit Apple Expo Entry
  • User
    • Register for Ongoing Raffles
    • Register new user
    • Edit User Settings
    • Logout
  • Contact
    • Customer Service
    • Webmaster Feedback
    • Submit News or PR
    • Suggest an article
  • Connect Tools
    • MacTech Live Podcast
    • RSS Feeds
    • Twitter

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

Introduction  |  Table of Contents

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

Would you like a hard copy
or PDF of this Guide?

You can get a hard copy sent to you
AND download a PDF now ($19.95)
, or

... just download a PDF ($9.95).

Either way, you get a complimentary
MacTech Magazine Subscription

courtesy of the
Microsoft Mac Business Unit


 

  Magazine Reg. Price:  $50.00 value  
  Guide Reg. Price:  $40.00 value  
  You Save:  over $80.00!  

April, 2007
Page 16



    -- check to see if Word is already running, for later  

    tell application "System Events"

        set wordWasRunning to exists process "Microsoft Word"

    end tell

    try

        tell application "Microsoft Word"

            -- no need to make Word visible, nor the option*

            activate

            set oDoc to make new document

           

            -- code here to manipulate the document

           

            close oDoc saving no

            if not wordWasRunning then quit

        end tell

    on error errMsg number errNum

        -- bring current application (e.g., Excel) to the front to view dialog

        activate

        display dialog "Word caused a problem. " & errMsg & ¬

            return & "Error: " & errNum with icon 0

        if not wordWasRunning then

            tell application "Microsoft Word" to quit

        end if

    end try

    -- no need to release object references

end ControlWord

 

Of course without all my explanatory comments the script would be even shorter. Notice that we ask System Events (a faceless background application with a very interesting dictionary – you can find it in /System/Library/CoreServices, if you want to browse it) to tell us if Word, as a process, exists, since there's no way to mimic the VBA method of trying to create a new Word instance (which errors if one exists already). Also note that Word (i.e., the application class in Word's dictionary) does not have a visible property, although window does, so you can certainly hide and show individual windows.

If you want to hide (or show) the whole application, you would do that in System Events, where you can set the visible property of any process, including Word. (The Finder can still do the same thing, at the moment, with its "legacy" commands, but these process features are now actually done by System Events: the Finder would just pass on the command, and some day may no longer do so.) This is a basic difference between the Mac and Windows: the system, rather than the application itself, controls things like visibility of applications.

Also note that in AppleScript you need to put a 'try' somewhere in order to catch an error. Usually, if one wanted to put the try block around the whole content of this ControlWord() handler, you'd put it around the call to the handler rather than inside it.

Also, note that in OS 10.4 (Tiger) that call to Word to quit inside the on error block will be well-behaved, but in OS 10.3 and earlier, if by any chance Word had already quit, this new tell statement would launch Word only to quit it!

What is Missing? What Are Your Options?

There are four big features of Office VBA that are missing from the AppleScript implementation. We've touched on one of them in discussing the script menu: you cannot run scripts from toolbar buttons. This will no doubt distress some people who like to run their macros this way, but at least you can run the scripts from a menu.



< Previous Page Next Page>
 
MacTech Only Search:
Community Search:

 
 
 

 
 
 
 
 
  • SPREAD THE WORD:
  • Slashdot
  • Digg
  • Del.icio.us
  • Reddit
  • Newsvine
  • Generate a short URL for this page:



MacTech Magazine. www.mactech.com
Toll Free 877-MACTECH, Outside US/Canada: 805-494-9797
MacTech is a registered trademark of Xplain Corporation. Xplain, "The journal of Apple technology", Apple Expo, Explain It, MacDev, MacDev-1, THINK Reference, NetProfessional, Apple Expo, MacTech Central, MacTech Domains, MacNews, MacForge, and the MacTutorMan are trademarks or service marks of Xplain Corporation. Sprocket is a registered trademark of eSprocket Corporation. Other trademarks and copyrights appearing in this printing or software remain the property of their respective holders.
All contents are Copyright 1984-2010 by Xplain Corporation. All rights reserved. Theme designed by Icreon.
 
Nov. 20: Take Control of Syncing Data in Sow Leopard' released
Nov. 19: Cocktail 4.5 (Leopard Edition) released
Nov. 19: macProVideo offers new Cubase tutorials
Nov. 18: S Stardom anounces Safe Capsule, a companion piece for Apple's
Nov. 17: Ableton releases Max for Live
Nov. 17: Ableton releases Max for Live
Nov. 17: Ableton releases Max for Live
Nov. 17: Ableton releases Max for Live
Nov. 17: Ableton releases Max for Live
Nov. 17: Ableton releases Max for Live
Nov. 17: Ableton releases Max for Live
Nov. 17: Ableton releases Max for Live
Nov. 17: Ableton releases Max for Live
Nov. 17: Ableton releases Max for Live