Attach to running excel as MHTML

[Anonymous]

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?

[MichaelAnnis]

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.

[Anonymous · Accepted solution]

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 🙂