Applescript - How to get quotes inside a formula?

Discussion in 'Mac Programming' started by rdelmar, Dec 15, 2008.

  1. rdelmar macrumors newbie

    Joined:
    Dec 15, 2008
    #1
    I am trying to use Applescript to enter a formula into an Excel worksheet, something like this: "=if(A1="","",A2=A1*$P$24)", but Applescript doesn't accept the quotation marks inside the string. I have accomplished in VBA by using Chr(34) in place of the quotation marks, but Applescript gives me an error on this too. How do I get around this problem? (I'm using OS X Leopard with Excel 2004)
     
  2. Sayer macrumors 6502a

    Sayer

    Joined:
    Jan 4, 2002
    Location:
    Austin, TX
    #2
    Put a backslash before each quote such as: \"\"
     

Share This Page