• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Excel Cell Format Question
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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
  • Follow-Ups:
    • Re: Excel Cell Format Question
      • From: Oakley Masten <email@hidden>
References: 
 >Excel Cell Format Question (From: Oakley Masten <email@hidden>)

  • Prev by Date: Re: Shell Scripting Sqlite
  • Next by Date: Re: Shell Scripting SQLite
  • Previous by thread: Excel Cell Format Question
  • Next by thread: Re: Excel Cell Format Question
  • Index(es):
    • Date
    • Thread