Re: The Excel 2004 battle continues
Re: The Excel 2004 battle continues
- Subject: Re: The Excel 2004 battle continues
- From: Robert Poland <email@hidden>
- Date: Wed, 30 Nov 2005 06:48:25 -0700
Hi,
Much thanks for all the help I'm getting.
My 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. Variations of this get me a list of one
item or nothing. Seems like this should be easy
This will work;
set text item delimiters to tab
tell application "Microsoft Excel"
activate
set dex to 928
set daysData to {}
set xdateRange to "A" & dex & ":N" & dex
set xdatas to value of range xdateRange as string
end tell
set x to text item 4 of xdatas
set text item delimiters to ""
x
But I'm having problems implementing it.
Help
TIA,
--
Bob Poland - Fort Collins, CO
http://www.ibrb.org/
This one was Easy (not really) Quit Smile and relaunch cured it.
--
Bob Poland - Fort Collins, CO
http://www.ibrb.org/
_______________________________________________
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