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



     set selectedShape to my GetSelectedShape() -- paste it in!

     tell text range of text frame of selectedShape

          tell its font

              set {font name, font size, font color, bold} to ¬

                   {"Arial", 24, {255, 0, 0}, true}

          end tell

     end tell

end tell

In AppleScript you can set those four properties (or as many as you want) of the font all in one line as a list. Note: This only works in a tell block to the object in question, not in an of format, although you can always get a list of properties using of font.

Working with just portions of the text in a shape

Test out this macro by running it from the UI, via Tools/Macros, rather than in the VBE Editor, so you can see what's going on as it runs. Don't use text that's too long because you're going to get a new MsgBox for every character in the first part. There are four parts: the first part makes every second character blue after flashing each character in a MsgBox; the second turns each word a different shade of green after flashing each word; the third displays each complete "run" of formatted text with the Long representing its RGB value; and the fourth just displays an arbitrary portion of the text : 6 characters starting from character 3.

Sub WorkWithPartOfText()

 

Dim x As Long, g As Long

With ActiveWindow.Selection.ShapeRange.TextFrame.TextRange

' access one character at a time

For x = 1 To .Characters.Count

MsgBox .Characters(x)

                ' make every second character blue

' if x divided by 2 = x mod 2 ...

If x / 2 = x \ 2 Then

.Characters(x).Font.Color.RGB = RGB(0, 0, 255)

End If

Next

' or a word at a time:

g = 0

For x = 1 To .Words.Count

MsgBox .Words(x)

'make every word a different shade

g = g + 100

If g > 255 Then g = 0

.Words(x).Font.Color.RGB = RGB(0, g, 100)

Next

' or a "run" at a time

' every change in formatting starts a new run

' if the number of runs in a textrange is 1,

' you know that all of the text

' in the range is formatted identically.

For x = 1 To .Runs.Count

' For each run, display the text and the Long that

' represents the text's RGB color

MsgBox (.Runs(x).Text & " - " & .Runs(x).Font.Color.RGB)

Next

 

' or arbitrary selections of text

' 6 characters starting at position 3, for example

MsgBox .Characters(3, 6)

 

End With

Again, this is mostly very straightforward in AppleScript, with just one or two adaptations needed, mentioned at the end:

tell application "Microsoft PowerPoint"



< 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