Re: Saving in Excel 2008
Re: Saving in Excel 2008
- Subject: Re: Saving in Excel 2008
- From: Deivy Marck Petrescu <email@hidden>
- Date: Wed, 11 Feb 2009 19:26:38 -0500
On Feb 11, 2009, at 6:32 PM, Stan Cleveland wrote:
On 2/11/09 3:18 PM, "Shane Stanley" wrote:
Be careful with document 1 -- it might not be what you think (it's
based on
opening order). Here are a couple of working examples:
set deskPath to path to desktop as Unicode text
save workbook as active workbook filename (deskPath & "test1.xls")
save as sheet 1 of workbook 1 filename (deskPath & "test1.txt")
file
format text Mac file format
Deivy, this also works (and the syntax is easy to understand):
set deskPath to path to desktop as Unicode text
save workbook "Workbook2" in (deskPath & "test1.xls") ¬
as workbook normal file format
Stan C.
Stan, actually one problem I see with this syntax is, if "workbook 1"
does not work as expected, I would have to keep track of the names of
the workbooks.
that would not be good to automate something.
But tomorrow I'll try : "save workbook active workbook in ..."
Oh! Thanks for the "as workbook normal file format" I looked for
something like that but could not find!
Deivy Petrescu
email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden