Answered

Attach to running excel as MHTML

Like (0) Share

Report

Posted on 2 Aug 2021 13:02:53 by Community Power Pla...

Hi, I just discovered so amazing and powerful tool which is power automate.

I want to save export from SAP which comes as a spreadsheet, but saved in an MHTML extension, that opens in SAP, I was willing to attach to running excel named: export.MTHML / export / export.MHTML - Excel and nothing works I am getting the error: "No Excel document found named export.MHTML.", the file from SAP are getting saved as export.MHTML - I can save with XLS as well, but there are many issues with this file as spaces in a cell before the wanted value begins.

Can you help me out?

Categories:

Process Advisor

All responses (2)

Answers (1)

Verified answer

Community Power Pla... on 08 Aug 2021 at 08:19:04

Like (0)

Report

Re: Attach to running excel as MHTML

I have reached my goal but in a different way.
I made changes in flow where the file with MHTML has been opened by VBS, there I have add step that is closing window named as "export.MHTML - Excel", second step is open Excel instance with existing file - I have choosen path to file export.MHTML
Finally I'm able to manipulate the file 🙂
MichaelAnnis 5,721 Moderator on 02 Aug 2021 at 13:08:51

Like (0)

Report

Re: Attach to running excel as MHTML

PAD has a "Rename File" command which has a "Rename Scheme" parameter which can be set to "Change Extension." I wonder if changing the file extension AFTER download it as MHTML would solve your problem.
Then you could manipulate it in Excel, save, and close.
After doing so, use the same command to change it back to MHTML.

Best of luck.