Delete a workbook while in a macro

[Guest]

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.)

 

[Ron de Bruin]

Hi jthurnwps

Look at the Kill command in VBA help