Hello I am using the following Applescript to open a Template File and save one worksheet as a CSV file.... but I want to save it on my desktop. Instead the file ends-up in the folder in which the original Template is located.
How can I make the new file: "nabestellingen.csv" to end up on my Desktop? Or another location of my liking
------- I use the following AppleScript -------
tell application "Microsoft Excel"
open workbook workbook file name "000_Schoolnaam01.xltx"
activate object worksheet 6
select (range "A1:A112")
save as active sheet filename "nabestellingen.csv" file format CSV file format
end tell
-------------
Change the filename in the save as statement to: "your hard drive
name:USERS:your name:DESKTOP:nabestellingen.csv"
--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom