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:15:35 -0500
On Feb 11, 2009, at 18:48, Shane Stanley wrote:
On 12/2/09 10:32 AM, "Stan Cleveland" <email@hidden> wrote:
this also works
Right. The potential disadvantage of this form, though, is that it
doesn't
give you access to some of the other optional save as parameters,
especially
overwrite and add to most recently used list.
--
Shane Stanley <email@hidden>
AppleScript Pro Florida, April 2009 <http://scriptingmatters.com/
aspro>
Firstly, Shane sorry for the duplicate. My bad.
Secondly, I wrote a small script to create a excel file and tried to
save it.
So I only had one file/workbook/document open.
I am sure I did not try: save workbook as active workbook filename
(deskPath & "test1.xls")
I am sure I did not use active workbook.
And it was not smart because in excel X one uses " save ActiveWorkbook".
Also, I forgot to put the ".xls" , but that should not be a problem,
at least not for the script.
I however do not understand:
" save as sheet 1 of workbook 1 filename (deskPath & "test1.txt") file
format text Mac file format" --one line
What is this doing exactly?
Now, Stan I did not actually wrote:
save workbook "Workbook2" in (deskPath & "test1.xls") as workbook
normal file format -- one line
but having one workbook open and using
save workbook 1 in (deskPath & "test1.xls")
does not work! So apparently workbook 1 is really very different than
one should expect.
In terms of speed, excel, and principally excel X is a demon.
Even more so if you compare it with scripting Numbers.
The dictionary has no comparison. Excel's dictionary obliterates
Number's.
However it is much more intuitive to script Numbers than Excel.
Another point I noticed and goes as a hint to Xcel-08.
If you have scripts for previous versions of excel, try to open and
save the script as text.
Then try to use the same script for xcel-08.
You will have more hits than misses.
Sometimes the terminology was kept but the AppleEvent was changed.
Deivy
_______________________________________________
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