HI,
I need to write a section of code that can access a cell in Applescript 6 and then use that value in another place, such as after a string. So I need a command line that will set the result as a variable.
Any help?
Thanks
Tyler
tell application "AppleWorks 6"
cell "A1" in document 1
end tell
set result to spreadsheetdata_01
Tyler:
Try this to start:
tell application "AppleWorks 6"
tell spreadsheet layer of front document
set a to {cell "A1", cell "b5"}
set b to cell "b1"
end tell
end tell
a & b
--> {"Position", 503, "Key Data"}
You must direct AppleWorks to talk to the spreadsheet layer in order to get any information out of it. Then, you just set the variables to whatever cell you are interested in like in the script above. The data is returned in whatever type is contained in the spreadsheet cells (number, string, etc.) and as you can see, you can access a list of cells or just one at a time.
Hope this helps, good luck.