Deleting specific worksheet in a workbook

[azizrasul]

Does anyone have a sub routine where I pass the details of an external workbook and worksheet and have that worksheet deleted?

Thanks in advance.

 

[Andrew Poulsom]

Example:

Application.DisplayAlerts = False
Workbooks("Book1.xls").Worksheets("Sheet1").Delete
Application.DisplayAlerts = True

Change the workbook and worksheet references to suit.

 

[azizrasul]

Thanks Andrew.