Apple

On Mar 27, 2015, at 04:26, Felix Zumstein <email@hidden> wrote:

But I discovered an issue with AppleScript directly - saving doesn't work properly:

tell application "Microsoft Excel"
set new_book to make new workbook
save workbook as new_book filename "test.xlsx"
end tell

______________________________________________________________________

Hey Felix,

I think you've missed the correct syntax, but I'm testing in Excel 14.4.8 - so you'll have to double-check.

When you create new_book it is already of class workbook, so you don't need to refer to it as workbook <name>.

In any case this syntax is incorrect:

save workbook as new_book filename "test.xlsx"

This works:

-----------------------------------------

set saveDir to path to downloads folder as text

set newExcelFilePath to saveDir & "test.xlsx"

tell application "Microsoft Excel"

activate

set new_book to make new workbook

save new_book in newExcelFilePath

end tell

-----------------------------------------

If you don't give Excel the full path to the new file it will be saved in the last directory where a file was manually saved.

Best Regards,

Chris

References:
	>Re: Best way to script Excel 2016 from Python (From: has <email@hidden>)
	>Re: Best way to script Excel 2016 from Python (From: Felix Zumstein <email@hidden>)
	>Re: Best way to script Excel 2016 from Python (From: Christian Prinoth <email@hidden>)
	>Re: Best way to script Excel 2016 from Python (From: Felix Zumstein <email@hidden>)
	>Re: Best way to script Excel 2016 from Python (From: Christopher Stone <email@hidden>)