Dear all,
I need a solution to delete multiple sheets from a single workbook which it creates on runtime with a timestamp. (e.g. “COVID-19-Pandemic Data-25-05-2020-10.56.11.xlsx”)
I wanted to delete the repeated sheets and keep only (COVID19_Final_Report) from excel workbook, Can you please provide me the solution.
Thanks in advance!
Anand Kumar
Hello @ImPratham45,
I tried to run your xaml file, I am getting Invoke VBA: File not found.
Thanks
Anand Kumar
sorry i havent send you
SheetToDel.txt (102 Bytes)
Hi @ImPratham45,
Thank you, It’s working fine now, but I am looking for a solution that excel file tabs need to be deletedWorldometer.xaml (52.3 KB) automatically without popup message. I hope you understand my requirement, I have attached my XAML file can you run and check the output of excel file.
Regards
Anand
Hello @balupad14,
Thank you, I already tried this solution, the problem is since my excel is creating on runtime with the timestamp, I am getting error like this (e.g. “COVID-19-Pandemic Data-25-05-2020-10.56.11.xlsx”) is not found or moved or deleted.
Regards,
Anand
I will send it tomorrow
Can you send me your sample workflow ?
Regards
Balamurugan.S
Hello @balupad14, Please find attached workflow, Let me know if need any further information.
Thanks
Anand Kumar
Worldometer.xaml (52.3 KB)
Sure, no problem, Thanks again for your support and quick response.
Thanks
Anand Kumar
Replace older text file with this one
SheetToDel.txt (171 Bytes)
Hi @ImPratham45,
Thanks for the solution, Now my workflow is working as expected. Thanks a lot for your support.
Regards
Anand
Your Most welcome!
Happy Automation
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.