Excel Application Sheet Deletion *RESOLVED*

[pavan]

Hi all,

I'm calling excel from VB and trying to post data into it. I've been sucessfule in that.
however, I need to delete all empty sheets in excel. and only one sheet viz., into which i've to post the data should be remaining in the work book. I've incorporated the code to delete sheets however, when the statement is being exceuted delete confiramtion dialog pops up. I would like to know how to supress the delete confirmation dialog.

Thanx

[si_the_geek]

Replace "xlApp" with your reference to the Excel application

xlApp.DisplayAlerts = False
< delete code >
xlApp.DisplayAlerts = True

If you don't turn on DisplayAlerts afterwards you will find Excel does everything without asking when you run it manually too (which really isn't nice!)

[pavan]

Originally posted by si_the_geek
Replace "xlApp" with your reference to the Excel application

xlApp.DisplayAlerts = False
< delete code >
xlApp.DisplayAlerts = True

If you don't turn on DisplayAlerts afterwards you will find Excel does everything without asking when you run it manually too (which really isn't nice!)

Thanks for the Help