| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deletions
Using MS Excel 2003
I have 2 workbooks open in my Excel window. Wb1 catches the exported data from QuickBooksPro (in doing this, QB overwrites any data that is on a worksheet already, precluding my dumping the export directly onto my template. Ugh!! Wb2 is my template and is linked to Wb1 to get the data into the cells to generate my report from the template without messing with my col/row headings, formulas etc. Now, when I close Wb1, I want to delete the ws, which will always be sheet1. I need help with the syntax on this please. Then, when I close Wb2, I want to dump all of the linked info so my template is empty and ready for the next time I need to use it. Again, this is where I need help with the syntax. Any guidance you can offer will be much appreciated. Thanks Joanne |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct range changing with deletions | Excel Worksheet Functions | |||
| Automatic deletions | Excel Discussion (Misc queries) | |||
| Because of row/column deletions, how do you reset the last cell? | Excel Discussion (Misc queries) | |||
| Prevent Worksheet Deletions | Excel Worksheet Functions | |||
| Data Form Deletions | Excel Discussion (Misc queries) | |||
Threaded Mode
