Delete worksheet in Excel


#1

Hi Team, I would like to delete worksheets in excel file on background… How can i achive this programatically like to use method sheetname.delete(). I don’t want to use open excel and then use options to delete sheet.


#2

Hello team, Please suggest if there’s any way to achive this? let me know in case of any queries.


#3

How about executing a macro in Excel application scope? Not sure if delete functions are exposed for WorkbookApplication and I don’t get intellisense.

Sub Delete_Sheet()
Application.DisplayAlerts = False
Worksheets("Robot").Delete
Application.DisplayAlerts = True
End Sub

#4

And what about if i want to pass sheet names from uipath to macro based on that i need to delete it