AppleScript to save as PDF not working
This script no longer works.
tell application "Microsoft Excel"
save as active sheet filename "test.pdf" file format PDF file format with overwrite
Adobe Wan Kenobe commented
This AppleScript command stopped working for me about two weeks ago for no apparent reason. This syntax and several variations of it work for other formats, just not PDF. It also displays an alert about "Error while printing" even though it's saving, not printing.
I now notice that instead of saving in the current directory it saves in the ~/Library/Containers/com.microsoft.Excel/Data/Documents path. It will not save to a given path either posix or hfs.