Welcome to Soft32 Forums!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

AppleScript Save to desktop instead of original file locat..

 
   Soft32 Home -> Mac -> Excel RSS
Next:  Jolly Roger's X-Face  
Author Message
qryn

External


Since: Oct 30, 2009
Posts: 2



(Msg. 1) Posted: Fri Oct 30, 2009 8:34 am
Post subject: AppleScript Save to desktop instead of original file location
Archived from groups: microsoft>public>mac>office>excel (more info?)

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

-------------
Back to top
Login to vote
Bob Greenblatt

External


Since: Jun 08, 2005
Posts: 809



(Msg. 2) Posted: Fri Oct 30, 2009 11:20 am
Post subject: Re: AppleScript Save to desktop instead of original file location [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On 10/30/09 11:34 AM, in article 59b7fa3c.-1 DeleteThis @webcrossing.caR9absDaxw,
"qryn@officeformac.com" <qryn DeleteThis @officeformac.com> wrote:

> 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"

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom
Back to top
Login to vote
Display posts from previous:   
Related Topics:
In this scenario, the original file is not removed quickly.. - I have Excel 2004 on a Mac with os x 10.4.8. When I try to save changes to an Excel file on a Windows 2003 server I get...

Makro should save a textfile on desktop... - Hi! I have an excel makro which saves a text file from an marked column. The Excel File is on a server in the network..

Applescript save as CSV - Hi, At the end of my Applescript, I have a line to save as CSV. save workbook as active workbook filename "finis...

Save as CSV applescript problem - Hi, I am new to applescript but have managed to write a droplet that takes all excel files, strips away all unneeded..

AppleScript: Save As Text (Tab Delimited) - I'm trying to find the AppleScript equivalent of saving a sheet as tab- delimited text, but I'm either misunderstanding...

No File name in "SAVE AS" - HELP! When I update an excel file and go to save it with a new name using "save as" the resulting window ha...
       Soft32 Home -> Mac -> Excel All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum

Categories:
 Windows
 Linux
  Mac
 PDA


[ Contact us | Terms of Service/Privacy Policy ]