Applescript - How to get quotes inside a formula?

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

  1. rdelmar macrumors newbie

    Dec 15, 2008
    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


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

Share This Page