Re: Excel 2004 & text color
Re: Excel 2004 & text color
- Subject: Re: Excel 2004 & text color
- From: Larry McMunn <email@hidden>
- Date: Sun, 10 Apr 2005 19:14:04 -0400
At 5:22 PM -0400 4/10/05, Hanaan Rosenthal wrote:
>Larry,
>try to address the range object in a tell block:
>
>tell application "Microsoft Excel"
> tell used range of sheet 1
> set font color index of font object of it to 1
> end tell
>end tell
>
>I'm not sure why this works and a direct command to the object doesn't...
>I also changed 'color index' with 'font color index'.
>
>Hanaan
Thank you sir, you are a gentleman and scholar. I find this new Office suite and the changes to Illustrator and InDesign are taking a lot of effort to master. I got your book shortly after it was released but have been too busy to immerse myself in it.
--
Happy Automation! :-)
Larry McMunn
President
McMunn Associates, Inc.
Specialists in automated Data Visualization through Apple products
Collingswood, NJ
(856) 858-3440
---------------------------------------------------------------
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden