I tried following to permanently delete a worksheet from an excel workbook, however it is not working as expected,
CType(oWB1.Sheets("ABC"), Excel.Worksheet).Delete()
What is wrong here?
oWB1.Application.DisplayAlerts = False
oWB1.Sheets("ABC").Delete
oWB1.Application.DisplayAlerts = True
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With