Delete a workbook with a macro

[4281967]

I have a macro that takes data from several workbooks and combines it into one (new) workbook. Since the old ones are no longer needed, it would be nice if I could have some code delete them for me. Is this possible?

Thanks

 

[kpetursson]

How about simply tring to record the action you want to take?

this will do it, but it prompts you to make sure you want to delete the sheet.

Sheets("Sheetname").Delete

Kevin Petursson
--
"Everyone says quotable things everyday, but their not famous... so nobody cares."... Some Person