Scripting Excel
Scripting Excel
- Subject: Scripting Excel
- From: Robert Poland <email@hidden>
- Date: Sun, 3 Jul 2005 16:06:29 -0600
Hi,
I hope someone ,like me, is sitting around with nothing better to do...
I'm attempting to use the script that Michael
Ghilissen posted recently to do some graphs. But
first I need to be able to extract data from an
Excel file.
The script so far;
set myFile to "iMac
HD:Users:rpoland:Documents:clutter: Medical :BP
Monitor :BP Monitor"
tell application "Microsoft Excel"
if (Window whose Name contains "BP
Monitor") exists then -- Apparently not a valid
idea with Excel
else
Open myFile
end if
Select Worksheet "Averages"
set Sys to Values of {Cells of Range "R7C3:R7C6"}
-- produces error
--Can't get Values of {Range
--R7C3 R7C6 of Worksheet "Averages"
--Of Workbook"BP Monitor'of
--Application "Microsoft Excel"}
end tell
I would like to be able to grab a "list" and use it to plot data.
Tia,
--
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