Re: Extracting data from a spreadsheet
Re: Extracting data from a spreadsheet
- Subject: Re: Extracting data from a spreadsheet
- From: Mark Butcher <email@hidden>
- Date: Sun, 28 Jul 2002 15:33:19 -0700
Paul Garfield wrote:
tell application "AppleWorks 6"
activate "contacts.xls"
-- set a fixed cell for test only
set cellNAME to "A2"
-- THIS IS THE BIT WHICH DOES NOT RESPOND
set x to contents of cell cellNAME
end tell
I think you are missing the reference to the spreadsheet of the window.
Unfortunately, I cannot find the syntax, but it is something like:
set x to contents of cell cellNAME of front spreadsheet of window
"contacts.xls"
HTH
MarkB
_______________________________________________
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.