AppleScript Save to desktop instead of original file location

Q

qryn

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

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

-------------
 
B

Bob Greenblatt

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top