• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: AppleScript commandsa for AppleWorks Spread Sheets
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: AppleScript commandsa for AppleWorks Spread Sheets


  • Subject: Re: AppleScript commandsa for AppleWorks Spread Sheets
  • From: Robert Christy <email@hidden>
  • Date: Tue, 28 May 2002 16:24:27 -0700
  • Organization: N/A

Since macros are no longer supported in the latest version of AppleWorks I am looking to AppleScript to take their place. I have quite a few AppleWorks spread sheets wherein I track and graph data trends. I have written macros to manipulate the spread sheet cells.

I would like to manipulate the cells using AppleScript. Specifically I need AppleScript commands that will do all of the following;
1) Select an individual cell
2) Copy the cell contents
3) Paste the contents to another cell
4) Paste the value only (paste special) to another cell
5) Do 1, 2, and 3 of the above with a range of cells

Below is the script I have written to get me to a particular spread sheet and it works but once there I have not been able to write anything that accomplishes any of the above tasks.

tell application "AppleWorks 6"
activate
open file "Macintosh HD:AppleWorks 6:AutoSave:My Stuff Copy:Crude Oil Futures"
tell file "Crude Oil Futures"
end tell
end tell


I have looked carefully at the AppleWorks dictionary, studied AppleScript Language Guide, and read AppleScript in a Nutshell. I am still lost.

I welcome and appreciate any and all help, hints, or suggestions.

Thank you for considering my problem.

Bob Christy
_______________________________________________
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.

  • Follow-Ups:
    • Re: AppleScript commands for AppleWorks Spreadsheets
      • From: T&B <email@hidden>
  • Prev by Date: Re: AppleScript gets incorrect file name - OSX
  • Next by Date: Changing a button's icon
  • Previous by thread: 24U has released 24U Appearance OSAX 2.0 for Mac OS X
  • Next by thread: Re: AppleScript commands for AppleWorks Spreadsheets
  • Index(es):
    • Date
    • Thread