RE: Excel 2004 - How to set fill color of cells?
RE: Excel 2004 - How to set fill color of cells?
- Subject: RE: Excel 2004 - How to set fill color of cells?
- From: Dennis Cox <email@hidden>
- Date: Fri, 2 Dec 2005 13:25:01 -0600
> From:
> applescript-users-bounces+dcox=email@hidden on behalf
> of Scott Babcock
>
> Try this:
>
> tell application "Microsoft Excel"
> set color index of interior object of range "A1" of active sheet to
> 3
> end tell
>
> > I know this must be really simple, but I have spent several hours trying
> > to
> > figure out how to set the cell color in Excel 2004 and the closest I get
> > is:
> >
> > tell application "Microsoft Excel"
> > tell document 1
> > set color index of interior object of style object of cell 1 of
> > row
> > 1 of active sheet to 3
> > end tell
> > end tell
> >
> >
> >
> > Which for some reason, that is totally beyond me, colorizes of all
> cells.
> >
> > Can someone please tell me what I am doing wrong?
>
I'm guessing you didn't read the Excel 2004 AppleScript Reference. Many
things have changed in Office 2004, including how to refer to objects. I
mean this in the kindest way: if you want to script Office 2004, get the
references. Read especially "Using the Excel/Word/PowerPoint Dictionary"
<http://www.microsoft.com/mac/resources/resources.aspx?pid=asforoffice>
Dennis
> >
> >
> > // Richard
> _______________________________________________
>
_______________________________________________
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