Hello! anyone...

i cant delete the sheet i have added in my excel file. i already tried below codes to delete it but it doesnt work... and i'm not getting any error which is why i dont know what is the problem....

worksheet.Delete()
workbook.sheet("sheettobedeleted").delete()

hi waddell.. i already tried that link.. and it didnt work for my project. it seems that i'm missing something in here, i don't know what. And i cant trace it because i'm not getting any error.

hey... nevermind... i already solved it.. i'm missing below codes.

excelapp.DisplayAlerts = False

Ah yes, thats caught me out a few times too!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.