Re: AppleScript commands for AppleWorks Spreadsheets
Re: AppleScript commands for AppleWorks Spreadsheets
- Subject: Re: AppleScript commands for AppleWorks Spreadsheets
- From: T&B <email@hidden>
- Date: Wed, 29 May 2002 17:23:04 +1000
Since macros are no longer supported in the latest version of AppleWorks
I am looking to AppleScript to take their place.
Have you been through the AppleScript tutorial at:
http://www.tandb.com.au/applescript/tutorial/
It actually uses AppleWorks for the examples. Most importantly, it shows
you where to look for the commands you need to do certain tasks and how to
interpret their use.
I would like to manipulate the cells using AppleScript. Specifically I
need AppleScript commands that will do all of the following;
Wrap each of my answers in this:
tell application "Appleworks 6"
activate
-- insert here
end tell
The "activate" is only needed for the copy and paste to work.
1) Select an individual cell
select cell "A1" in spreadsheet of front document
2) Copy the cell contents
copy to clipboard
3) Paste the contents to another cell
select cell "B2" in spreadsheet of front document
paste
4) Paste the value only (paste special) to another cell
paste values
5) Do 1, 2, and 3 of the above with a range of cells
select cells "A1" thru "B4" in spreadsheet of front document
copy to clipboard
select cell "D6" in spreadsheet of front document
paste
Tom
T&B
_______________________________________________
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.