Automator on Mac no longer is compatible with Excel for Mac
Previously, Automator could be used to perform a variety of functions with excel. Now, using excel with automator returns the error "The action “[ACTION]” encountered an error: “Microsoft Excel got an error: Parameter error.” Where [ACTION] is the particular Automator action you wanted to perform.
Could you please make these programs work together again?
Forget below... just found AppleScript. I think it works. Thanks.
As a rank beginner with automator, which automator action did you run that in? Was it Run Shell Script?
When I do that it comes up with an error essentially saying that the tell command wasn't found etc. Have attached the message.
The workaround I used was to create a Macro using VBA in Excel and then call that Macro using Apple Script
tell application "Microsoft Excel"
run VB macro "file.xlsm!MacroName"