| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Delete a workbook while in a macro
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.) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro broken with workbook name change | Excel Discussion (Misc queries) | |||
| Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
| how do I delete a worksheet from my workbook | New Users to Excel | |||
| Error when trying to delete a macro... | Excel Discussion (Misc queries) | |||
| Passing selected workbook name and values to a macro | Excel Worksheet Functions | |||
Hybrid Mode
