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.
Hello team, Please suggest if there’s any way to achive this? let me know in case of any queries.
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
And what about if i want to pass sheet names from uipath to macro based on that i need to delete it