Recalculation of AppleWorks Spreadsheet
Recalculation of AppleWorks Spreadsheet
- Subject: Recalculation of AppleWorks Spreadsheet
- From: mikeboyer <email@hidden>
- Date: Sat, 25 May 2002 22:07:15 +0100
I have a number of AppleWorks spreadsheets which refer to each other and
I want to ensure their synchronisation by doing the equivalent of a
"calculate now" menu command, on each file, from a script.
The AppleWorks 6 dictionary offers the "recalculate" command which I
assume is meant to do this. The actual dictionary entry is:
recalculate: Recalculate a spreadsheet
recalculate spreadsheet layer -- the spreadsheet to recalculate
Seems simple but it doesn't work for me. My several script attempts
(with the corresponding error messages) are as follows
set myfile to "Macintosh HD:Users:mike:testsheet" as alias
tell application "AppleWorks 6"
open myfile as document type spreadsheet --AppleWorks launches OK
activate
(1) recalculate -- Error : "AppleWorks can't
continue recalculate"
(2) recalculate myfile -- Error`: myfile "doesn't
understand the recalculate message"
(3) recalculate spreadsheet layer -- Error:
"expected eol but found command name"
(4) recalculate spreadsheet layer myfile -- Error: "expected
eol but found command name"
end tell
I am using OSX10.1.4.
Can anyone please advise me how this recalculate should work?
Thanks
Mike Boyer
_______________________________________________
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.