Re: Get all the ranges of a Excel spreadsheet
Re: Get all the ranges of a Excel spreadsheet
- Subject: Re: Get all the ranges of a Excel spreadsheet
- From: Sam Griffith <email@hidden>
- Date: Fri, 18 Apr 2003 01:31:39 -0500
You say it's a collection? Why not a List?
Also, why when I do something like so:
repeat with x in every item of Names
-- do something
end repeat
It doesn't it work? Tells me that Names doesn't understand "every". It
seems to me that the Excel collections don't behave like Lists and the
Collections class sure isn't documented in the AS Dictionary that I can see
in Script Editor...
Thanks for the help!
--
Sam Griffith Jr.
email: email@hidden
Web site:
http://homepage.mac.com/staypufd/index.html
On 4/17/2003 6:11 PM, "David Wignall" <email@hidden> wrote:
>
on 18/4/2003 8:11 AM, Sam Griffith at email@hidden wrote:
>
>
> Does anyone know how to write a script to get all the named ranges on a
>
> sheet in Excel X?
>
>
Names are a collection, ordered by alphabetic ascending for Names at the
>
workbook level. Thus
>
>
repeat with i from 1 to (count of Names)
>
display dialog (Name of Name (i) & " " & Value of Name (i))
>
end repeat
>
>
Unfortunately I can't see any way to find only the names for a particular
>
sheet, other than parsing the text returned for the Value or the RefersTo
>
properties.
>
>
If the Names are at the sheet level then they appear in the collection
>
before the workbook level Names. Again, I can find no way of restricting the
>
scope to any one sheet.
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.