Re:Saving in Excel 2008
Re:Saving in Excel 2008
- Subject: Re:Saving in Excel 2008
- From: Steve Digby <email@hidden>
- Date: Thu, 12 Feb 2009 11:46:20 +0000
- Thread-topic: Saving in Excel 2008
Hi,
I used often save new open workbooks with Applescript and rather than name
the workbook, I would use the Applescript below to name a sheet in the
workbook and then save the active workbook, which itself could be workbook
1, 2-etc.
tell application "Microsoft Excel"
set the name of the active sheet to "Database"
set deskPath to path to desktop as Unicode text
save active workbook in (deskPath & "test1.xls") ¬
as workbook normal file format
end tell
Also, I often save open workbooks that have been named previously and find
that as long as they are open and named, it does not matter which order they
are in, I can save as follows:
tell application "Microsoft Excel"
Activate Workbook "test.xls"
save (workbook "Test.xls")
end tell
> I used Excel 2008.
> I was able to successfully convert the script for 2004 for 2008.
> Everything was painless until the save command.
>
>
> I hope someone proves me wrong, but I think I tried all possible save
> and save as excel offered without any success.
> Closing and saving seemed to work but excel did not appear to care
> about where I wanted to save and what name to give the file.
>
> Thanks you for any hints
>
> Deivy Petrescu
> email@hidden
>
Lasgo Chrysalis Limited. Registered in England & Wales No. 1380166.
Part of the Chrysalis Group Plc.
Registered office: The Chrysalis Building, Bramley Road, London W10 6SP
_______________________________________________
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