Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Have two files that need to be deleted once the Workbook open macro is
(almost) done. NOTE: These files are in the exact same directory, on each of the computers. 1: File: QCNUM.xls - Regular working file. Contains Salesmans code number and Seqential number generator (on hidden sheet) 2: File: QCNUM_1.xls -is the new file I send out to each salesman 3: File: QCNUM_OLD.xls -to be a "back-up" of QCNUM.xls 4: File: Updater.xls: Strictly a file used to "manipulate the other files ONE time use only Updater Operations: Take pertinent info from QCNUM and put in identical sheets/cells in QCNUM_1 QCNUM Save as QCNUM_OLD QCNUM_1 Save As QCNUM Now I have no need for QCNUM_1 anymore. How can it be deleted? I also need to get rid of Updater. BUT, that's the one with the macro in it. Is the windows temp file always in the same tree? If so, could I rename the file as Junk.tmp, and have windows delete the file when it closes? OR .......................?? I want this file deleted, somehow, so it can't be "activated" a 2nd time. Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to delete multiple files? | Excel Discussion (Misc queries) | |||
How to delete multiple files? | Excel Discussion (Misc queries) | |||
How to delete archived files | Excel Discussion (Misc queries) | |||
How to delete archived tmp files | Excel Discussion (Misc queries) | |||
Delete .csv files in a folder | Excel Programming |