macOS Applescript - How to get quotes inside a formula?

[rdelmar]

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)

 

[Sayer]

Put a backslash before each quote such as: \"\"