Feedback by UserVoice

How can we improve Excel for Mac?

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?

1 vote
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Rhiannon Miler shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base