Excel: set value of cell & bold a column
Excel: set value of cell & bold a column
- Subject: Excel: set value of cell & bold a column
- From: "Willard L. McMunn" <email@hidden>
- Date: Sun, 05 May 2013 15:32:53 -0400
| Give this a try:
tell application "Microsoft Excel" tell active workbook tell active sheet
set value of cell "A5" to "XXX" set font style of font object of column 5 to "Bold"
end tell end tell end tell
I would like to modify the contents of an Excel document. I need to go into a specific cell , A:5, for example and change the text from "old text" to "my new text"
I would also like to format specific columns in bold.
Can anyone point me in the right direction or give me a little guidance?
----------------------------------------
Happy Automation,
Larry McMunn, President McMunn Associates, Inc. • Collingswood, NJ • Seminole, FL
(856) 393-4756 or Skype: wlarrymcmunn
"If you look backward in this business, you'll be crushed. You have to look forward" —Steve Jobs, 1955-2011
|
_______________________________________________
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