Re: The Excel 2004 battle continues
Re: The Excel 2004 battle continues
- Subject: Re: The Excel 2004 battle continues
- From: Shane Stanley <email@hidden>
- Date: Wed, 30 Nov 2005 20:18:42 +1100
- Thread-topic: The Excel 2004 battle continues
On 30/11/05 6:10 AM, "Robert Poland" <email@hidden> wrote:
> y next problem...
>
> set dex to 928
> set xdateRange to "A" & dex & ":" & "B" & dex
> set xdatas to value of range xdateRange as list
>
> Obviously this won't work.
Not if you don't address a sheet, it won't.
The value of ranges is returned as a list of lists, with the sublists
representing the values for a row. So if your values are "2" and "3":
tell application "Microsoft Excel"
set dex to 928
set xdateRange to "A" & dex & ":" & "B" & dex
set xdatas to value of range xdateRange of active sheet
end tell
would return {{"2", "3"}}
--
Shane Stanley <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:
This email sent to email@hidden