• 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 40



          -- variable to it so we just get it once

          tell findObject

              set {content, content of its replacement, forward, wrap, format, ¬

                   match case, match whole word, match all word forms, ¬

                   match sounds like, match wildcards} to {"^p^p", "^p", ¬

                   true, find continue, false, false, false, false, false, false}

          end tell

          execute find findObject replace replace all

         

          -- Find/Replace cannot delete first or last paragraph if empty, so:

          set myRange to text object of paragraph 1 of active document

          if content of myRange = return then delete myRange

         

          try

              set myRange to text object of paragraph -1 of active document

              if content of myRange = return then delete myRange

          end try

     end repeat

    

end tell

We use a plain repeat block since we do not know how many times we'll need to run it. (If we were to use repeat while (get text object of active document does not contain return & return) or a variable set to the same thing, it does not re-evaluate each time and the repeat loop never finishes (I've tried it). Instead we re-set the textObject variable just inside the repeat loop to force a re--evaluation, and then exit repeat under that condition.

That means that we also need to run the code to delete the first and last paragraphs if they are empty inside the loop; otherwise the text range will continue to have two paragraph marks at the very end if the last paragraph is empty – forever, and you'd never get out of the repeat loop. Finally, you need a try/end try block around the code deleting the last empty paragraph since it errors when it tries to delete myRange. It actually does delete the paragraph (just a 'return') but still errors. So a simple try/error gets around that.

In the above script, just use

set textObject to (text object of selection) -- redo each time

instead of text object of active document to have the Find & Replace work on selected text rather than on a whole document.

Working with Bookmarks

There are two interesting articles on the Word MVP website, by Ibby and by Dave Rado, about working with bookmarks:

<http://www.word.mvps.org/FAQs/MacrosVBA/WorkWithBookmarks.htm>

<http://www.word.mvps.org/FAQs/MacrosVBA/InsertingTextAtBookmark.htm>

This is not the place to repeat all their helpful tips and explanations, but just to check that everything they recommend can easily be done in AppleScript too. First go to Preferences/View, and check to Show Bookmarks so you can see what‘s happening.

To insert text at (that is, after) a placeholder bookmark (one where you inserted a bookmark at an insertion point in the text):



< 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