Re[2]: Uniquely identify range in MS Excel
Re[2]: Uniquely identify range in MS Excel
- Subject: Re[2]: Uniquely identify range in MS Excel
- From: Leonid Bogdanov <email@hidden>
- Date: Thu, 19 May 2011 09:15:35 +0400
Hello, Stan!
Ok, but how can I get a string representation of any range (cell, row, range consisting of several rectangular areas)?
Wed, 18 May 2011 12:08:20 -0700 letter from Stan Cleveland <email@hidden>:
> On May 18, 2011, at 3:57 AM, Leonid Bogdanov wrote:
>
> > Any thoughts on how to uniquely identify a MS Excel range by a number or a
> string key?
> > So that by this key one can quickly get a range from a collection of all
> ranges.
> >
> > I can't use its 'name' property, because after setting it, it will be
> visible by a user.
>
> Hi Leonid,
>
> Excel itself uses a 'range' object, of which the string portion looks like it
> might do the trick:
>
> set rangeKey to "[Workbook1.xls]Sheet1!$A$1:$D$14"
>
> tell application "Microsoft Excel 2008"
> set myFormulas to formula of range rangeKey
> tell font object of range rangeKey
> set {fontName, fontStyle, fontSize} to {name, font style, font size}
> end tell
> end tell
>
> Stan C.
>
> _______________________________________________
> 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
_______________________________________________
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