web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Close Multiple Excel F...
Power Automate
Unanswered

Close Multiple Excel Files

(0) ShareShare
ReportReport
Posted on by 5

I am trying to close multiple instances of Excel while saving them into a folder.

My Problem - I am not able to make the UI dynamic so that PADesktop closes the currently active excel file.

 

I have tried customizing the UI using a dynamic filename by creating a list but it did not work.

Can someone please help me or point me in the right direction.

 

Thanks

Chandeep

I have the same question (0)
  • MichaelAnnis Profile Picture
    5,727 Moderator on at

    Inside your loop, put this:

    MichaelAnnis_0-1627675857174.png

    It will get the window title: typically Boo1 - Excel.

    Windowtitle.Trimmed will make it Book1 or Book1.xlsx...not sure, but it works.

    Then, Close Excel saving it to whereever you need calling it whatever you want.  If this is a loop for several workbooks, I am sure you have a variable that you would like to put in the filename.

     

    Good luck.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 589

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 284 Super User 2026 Season 1

Last 30 days Overall leaderboard