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!
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.