Fix HTML export from AppleScript
Since 16.15, running the following AppleScript has either crashed Excel (versions 16.16–16.23) or (16.15 and since 16.24) produced a badly formatted HTML file.
tell application "Microsoft Excel" to save as active sheet filename theFolder & "test.html" file format HTML file format
Note that theFolder is a valid folder in the Office sandbox folder. The equivalent code in VBA works fine:
ActiveSheet.SaveAs FileName:=theFolder & "test.html", FileFormat:=xlHtml
Alternatively, could the VBA PublishObject object be added to the AppleScript dictionary?