Hi jthurnwps
Look at the Kill command in VBA help
--
Regards Ron de Bruin
http://www.rondebruin.nl
"jthurnwps" wrote in message ...
I have one macro in a template (A) which opens a different workbook (B) and
populates it then saves it. Because B is so large I created a second macro
in A which copies some of the sheets from B into a third workbook (C) and
saves that under a new name. Now I want to erase B as I don't need it
anymore. How can I set up my second macro in A to do that? (Hope I didn't
confuse anyone.)