Delete Multiple Excel Worksheets in one go

(0) Share

Report

Posted on by SA_VOH

231

Hi,

I have a Excel Workbook with 6 Excel Worksheets say 1,2,3,4 5 and 6.

I would like to delete 5 worksheets - say 1,2,3 4, and 6 in 1 one go and keep only worksheet 6 in the Excel Workbook.

Although there is a "Delete Worksheet" option (not Worksheets) in PAD, i would not like to place this 5 times and would like to go for deleting 5 Excel worksheets in 1 go.

Any idea will help

Categories:

Power Automate Desktop

I have the same question (0)

All responses (9)

Answers (2)

AS-06081019-0 1,736 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@SA_VOH Please refer below

Was this reply helpful? Yes No
SA_VOH 231 on at

Like (0)

Report
Copy link

Link copied!

Hi Ankesh,
Prima faice i have looked into your solution.
Thanks for the solution, I would like to retain Sheet 4 and delete all other worksheets.
So, i think that the Code should be CurrentItem <> Sheet 4.
Please confirm

Was this reply helpful? Yes No
AS-06081019-0 1,736 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Yes. Correct

Hope it helps!!

Cheers,
Ankesh
--------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
SA_VOH 231 on at

Like (0)

Report
Copy link

Link copied!

Hi Ankesh,
Ok.
Further, i think that i can do away with Display Message Loop and For Each Loop.
Only If- else Loop is sufficient, any comments please.

Was this reply helpful? Yes No
Verified answer

AS-06081019-0 1,736 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Here you go, below is what you can replicate at your end.

Hope it helps!!

Cheers,
Ankesh
--------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
SA_VOH 231 on at

Like (0)

Report
Copy link

Link copied!

Hi Ankesh,
Thanks, i accepted your solution.
But i require 1 help in this flow.
What if i want to preserve 2 Excel Sheets say Excel Sheet 4 and 5 instead of Excel Sheet 4 only.
What is the change then required in the If-Code?
Please help

Was this reply helpful? Yes No
Verified answer

AS-06081019-0 1,736 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Here you go:

Hope it helps!!

Cheers,
Ankesh
--------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
SA_VOH 231 on at

Like (1)

Report
Copy link

Link copied!

Thanks Ankesh_49, it worked. And i have marked it as Solution.

Was this reply helpful? Yes No
AS-06081019-0 1,736 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Awesome. Glad it helped @SA_VOH

Was this reply helpful? Yes No