Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

AppleScript Save to desktop instead of original file location

88 views
Skip to first unread message

qr...@officeformac.com

unread,
Oct 30, 2009, 11:34:31 AM10/30/09
to
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

-------------

Bob Greenblatt

unread,
Oct 30, 2009, 11:45:03 AM10/30/09
to
On 10/30/09 11:34 AM, in article 59b7f...@webcrossing.caR9absDaxw,
"qr...@officeformac.com" <qr...@officeformac.com> wrote:

Change the filename in the save as statement to: "your hard drive
name:USERS:your name:DESKTOP:nabestellingen.csv"

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

0 new messages