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