Change color of a cell's text in excel with applescript

Scripting Forums AppleScript | Mac OS X
#1

Hello,
I’m a new programmer with applescript and i would like to change the color of the text inserted in a cell of an excel worksheet. I did the following but nothing changed :

set color of font object of range “E17” of sheet 1 of active workbook to {255, 0, 255}

Can someone help me ? Thanks everybody,

Franck

Model: imac
AppleScript: V2.3 (118)
Browser: Safari 531.21.10
Operating System: Mac OS X (10.6)

#2

Hi,

the syntax works on my machine (Excel 2004).
You need also the application tell block


tell application "Microsoft Excel"
	set color of font object of range "E17" of sheet 1 of active workbook to {255, 0, 255}
end tell

you can also write active sheet instead of sheet 1 of active workbook


tell application "Microsoft Excel"
	set color of font object of range "E17" of active sheet to {255, 0, 255}
end tell
#3

Hy Stefan,
Thank you for reactivity. Unfortunately this command has no effect… no bug, no result !
I’m wondering if it is not a problem of excel version ???

Franck

#4

And after on week of search, i found the solution… Not to early :confused:
The solution is :

set font color index of font object of range “E17” of active sheet to 3

Thank you Stefan for your help.

Franck