Applescript and Excel 2004

[Eric SURIN]

Hello,

What is the good syntax to get the following simple line of Applescript code
(that works fine with Excel X) working with Excel 2004 ? I have tried to
find my way in the new Applescript dictionary of XL 2004 but to noavail...

Tell application "Microsoft Excel"
set FormulaR1C1 of ActiveCell to "Whatever value"
End tell

Thanks for your help.
Eric

 

[JE McGimpsey]

Hello,

What is the good syntax to get the following simple line of Applescript code
(that works fine with Excel X) working with Excel 2004 ? I have tried to
find my way in the new Applescript dictionary of XL 2004 but to noavail...

Tell application "Microsoft Excel"
set FormulaR1C1 of ActiveCell to "Whatever value"
End tell

Take a look at the Microsoft Excel Suite, application class (active
cell), and Table Suite, range class (formula, formula R1C1, etc).

one way:

tell application "Microsoft Excel"
set formula r1c1 of active cell to "whatever value"
end tell

 

[Fredrik Wahlgren]

Hello,

What is the good syntax to get the following simple line of Applescript code
(that works fine with Excel X) working with Excel 2004 ? I have tried to
find my way in the new Applescript dictionary of XL 2004 but to noavail...

Tell application "Microsoft Excel"
set FormulaR1C1 of ActiveCell to "Whatever value"
End tell

Thanks for your help.
Eric

There's a new reference guide for Excel and Applescript available:

http://www.microsoft.com/mac/resources/resources.aspx?pid=asforoffice

/ Fredrik