View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jthurnwps
 
Posts: n/a
Default Delete a workbook while in a macro

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