In a reply to an earlier post, digest4d gave me some great ideas to a problem I was having with Applescript and Excel 2004 (Thanks!) I was attempting to pass some variables from a VBA macro in Excel to another program. Digest4d pointed out that VBA will not pass variables to other applications and I should look at building my script in Applescript.
As a programming novice, I used the holiday we received from Hurricane Dennis (we were in the path, but no damage) to blunder through creating that script. It almost works!
Here is my current trouble spot in my script. I open an Excel spreadsheet in my script then save it as file01 as a text file using this line:
save workbook in file01 as text Mac file format
It works, but it pops several information windows asking if I want to save, asking where I want to save to letting me know that some features of worksheets cannot be saved in a text file.
How can I force the save without the questions?
In the Excel 2004’s dictionary for the save worksheet as command, there is an entry for something called conflict resolution. It sounds as if this may be the answer to my question, but I cannot figure out how to format that line.
Can you help? How can I format the “save” command in Excel 2004 and Applescript so that the script will execute the save without asking me to click on a bunch of information windows about that save operation.
Thanks for your help.
//steve
Model: i
Browser: Firefox 1.0.4
Operating System: Mac OS X (10.4)