Use Automator to save to PDF Office 365 Excel documents

AppleScripting Office applications is a black art.

That said, the changes you need are fairly trivial. The clues are in the dictionary for the respective apps.

This is the block in the original (Word) script.

	tell application id "com.microsoft.Word"
		activate
		repeat with i from 1 to count of selected_files
			open (item i of selected_files)
			set theOutputPath to (item i of outPDF)
			-- close access (open for access exportDocument)
			tell active document
				save as it file name theOutputPath file format format PDF
				close saving no
			end tell
		end repeat
	end tell

This is the equivalent for Excel:

	tell application id "com.microsoft.Excel"
		activate
		repeat with i from 1 to count of selected_files
			open (item i of selected_files)
			set theOutputPath to (item i of outPDF)
			tell sheet 1 of active workbook
				save as it filename theOutputPath file format PDF file format
				close saving no
			end tell
		end repeat
	end tell

Why Microsoft can't standardize across their Office apps, I don't know.

I have never written any AppleScript to save content from Microsoft applications to PDF.

I recommend that you continue searching on the web (e.g. MacScripter) to see if someone has done this using AppleScript. I also recommend that you look at the dates the articles were posted as you want examples from 2020 or later to ensure you have current Microsoft Excel AppleScript dictionary syntax, and not that from Office 2011 or even 2016.

Quite new to the AppleScript, running the above script on a Word file; Office 365, Norwegian language. The response was (translated from Norwegian): "Microsoft Word got an error: active document do not understand the message "save as". (-1708)"

Save as is Lagre som in Norwegian, so I changes save as to lagre som in the script

Compiled and the response from the script was pop-up window "syntax error, expected end of line, but found identification" (translated from Norwegian)

Any ideas how to solve?

I believe this is a Word Office365 combined with Sharepoint problem Used full path to a local Word file so at least able to get it to work with one specified file. Not sure how to make it work for several selected files.

Googled some more on the subject so I see that this could be related to path and file name..