hi, I am without any experience with applescript therefore I need some help.
This is my problem. I have created an Automator run. The Programm takes a excel file from my webdisc and send it to some mail receiver. Now I want to delete some columns and some sheets from this excel file. I want to write an applscript for this action. Here is my trial.
tell application “Finder”
activate
open document file "Liste AgHs aktuell.xls" of folder "impuls" of folder "Documents" of folder "user" of folder "Users" of startup disk
tell application "Microsoft Excel"
delete column 10 of sheet 1
delete column 11 of sheet 1
delete column 15 of sheet 1
delete column 5 of sheet 2
delete sheet "Beurteilung"
delete sheet "Stundennachweis"
delete sheet "Trainingsmaßnahme"
delete sheet "Auswertungen"
end tell
delay 20
end tell
tell application “Microsoft Excel”
save
quit
end tell
The problem is that Excel ask me “should I delete the sheet realy?” so, the script is waiting for my answer.
How could I stopp this question from excel? Or can I give a answer with applescript?
cosmo
Model: powerbook with tiger
Browser: Safari 416.13
Operating System: Mac OS X (10.4)