Answered

Close and save document in Power Automate Desktop

(0) Share

Report

Posted on by Crack-1703

My problem relates to the saving of Excel files in Power Automate Desktop.
The problem only started after 23-04-17 roughly .
Very simple flow will explain the problem
The flow : Launch Excel with an Excel file TEST.xlsm, then Wait(3) and then Close the excel Instance with Save the document
TEST.xlsm has a macro :- for "This-Work-book "- Sub "Work-book-Open" and just a "message-box"("Testing")

I open and close TEST.xlsm directly in Excel or 2xclick from the explorer - No Problem.
If I run the flow, It runs Ok but.....
If I try and open TEST.xlsm It open ( I know because of the message), but there are no sheets and all functionality is disabled.

Any ideas?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Crack-1703

Are you trying to say that when file TEST.xlsm is opened via PAD, there are no sheets available inside that ?

Was this reply helpful? Yes No
Verified answer

Riyaz_riz11 4,214 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Crack-1703
If you facing like that challenges that you can able to try with different approaches as well.
create a blank template and launch it and save that file into respective location.

Regards
Riyaz

If it works please mark as a solution so others will help and tumps up

Was this reply helpful? Yes No
Crack-1703 27 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the reply., I am getting so anxious about this issue. It has stopped all my development.
Yes, So the TEST.xlsm works ok opening the file everything 100% until I use the flow. After the flow is run and closed, if I open TEST.xlsm directly from Excel the little msg appears but there are no sheets.
Thanks for help

Was this reply helpful? Yes No
Crack-1703 27 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, thank you, I have tried that.
This issue started after 17th April, am I able to uninstall PAD and then install a previous version?

Was this reply helpful? Yes No
Crack-1703 27 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, - after the running the flow, then opening TEST,xlsm using Excel.exe displays the message but then there are no sheets. You can check the macro, but nothing else.

Was this reply helpful? Yes No
Riyaz_riz11 4,214 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes you can install previous version as well.

Was this reply helpful? Yes No
Crack-1703 27 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you for your replies.
I have sorted out the issue. I had a xlsm file with a macro but in PAD - Launch Excel \ Advanced I had not selected "Nest under a new Excel Process".
Thanks and take care

Was this reply helpful? Yes No
Crack-1703 27 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your replies.
I have sorted out the issue. I had a xlsm file with a macro but in PAD - Launch Excel \ Advanced I had not selected "Nest under a new Excel Process".
Thanks and take care

Was this reply helpful? Yes No