LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 247
Default Delete files with VBA

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to delete multiple files? Adnan Excel Discussion (Misc queries) 7 May 7th 09 10:49 AM
How to delete multiple files? Adnan Excel Discussion (Misc queries) 0 May 6th 09 05:31 PM
How to delete archived files Bob English[_2_] Excel Discussion (Misc queries) 1 January 29th 09 03:42 AM
How to delete archived tmp files Bob English Excel Discussion (Misc queries) 0 December 19th 08 08:32 PM
Delete .csv files in a folder John Excel Programming 2 May 2nd 06 07:08 PM


All times are GMT +1. The time now is 06:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"