Format Text in Excel

Scripting Forums AppleScript | Mac OS X
#1

I couldn’t find any examples of text formatting in excel.

Perhaps I was using the wrong keywords?

Anyway I wanted to post some examples for anyone who might need them:


tell application "Microsoft Excel"
	tell worksheet "Sheet1" of active workbook

set font size of font object of range "A1:H1" of worksheet "sheet1" to 11		
                
set bold of font object of range "A1:H1" of worksheet "sheet1" to true
		
set underline of font object of range "A1:H1" of worksheet "sheet1" to underline style single

	end tell
end tell

Good luck!

#2

Find more here: http://www.microsoft.com/mac/developers/default.mspx?CTT=PageView&clr=99-23-0&target=5d658edd-7803-4c66-884e-67d46e1e12891033&srcid=a7bd42c1-765a-4720-b82a-bd7a90650c021033&ep=7

#3

Do you have a question about formatting Excel via Applescript or are you posting a guide to more info about it?

If you have a question, I can’t understand what the question is. Could you restate it please?

Thank you.

#4

No question. I was trying to figure out how to do this for the first time today, and I couldn’t find any examples on the forum so I thought I would post some as future reference… for whoever might be interested.