Re: Excel Cell Format Question
Re: Excel Cell Format Question
- Subject: Re: Excel Cell Format Question
- From: Craig Sutherland <email@hidden>
- Date: Fri, 30 May 2008 14:57:08 -0500
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