Re: Excel Cell Format Question
Re: Excel Cell Format Question
- Subject: Re: Excel Cell Format Question
- From: Oakley Masten <email@hidden>
- Date: Fri, 30 May 2008 14:04:25 -0700 (PDT)
Craig
Thank you
Your process works great.
Oakley
--- Craig Sutherland <email@hidden> wrote:
> On May 30, 2008, at 12:50 PM, Oakley Masten wrote:
>
> > Hi All
> >
> > I need to set the format of cells in an excel doc
> that
> > I am creating using AppleScript.
> >
> > The cells appear to automatically come up as
> formatted
> > "General"
> > I think I need to set the format to "Text".
> >
> > What I need to do is to take a value from row 3
> column
> > 2 modify it and put it in the next column
> > ie row 3 column 2 might be "11942"
> > I want to change it to < AR11942> and put it
> in
> > row 3 column 3.
> >
> > I tried:
> > tell application "Microsoft Excel"
> > activate
> > tell active sheet
> > set value of cell 2 of column 12 to ("<AR" &
> ((value
> > of cell 2 of column 5) as text) & ">")
> > end tell
>
> In Excel 2004 this works for me-
>
> tell app "Microsoft Excel"
> activate
> tell active sheet
> set myValue to (value of cell 3 of column 2 as
> integer)
> set myValue to "<AR" & myValue & ">"
> set value of cell 3 of column 3 to myValue
> end tell
> end tell
>
> Craig
>
>
>
>
>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden