AidanEnos
Dec 9th, 1999, 03:34 AM
Hello :o)
I have an Excel sheet that uses about 30 text files (daily captured data) one at a time to cut and past the relevat info into a template to create graphs.
It all works great!
What I want to do is have the macro erase or move the files from the designated temporary directory so that the next days data can be used. I need to have them removed because in some instances one or more of the files is missing and if it's not a clean directory we get corrupt graphs with data collected from different days.
So basically what it needs to do is go to c:\temp and erase *.cap and N1*.txt
Thanks :o)
AidanEnos
I have an Excel sheet that uses about 30 text files (daily captured data) one at a time to cut and past the relevat info into a template to create graphs.
It all works great!
What I want to do is have the macro erase or move the files from the designated temporary directory so that the next days data can be used. I need to have them removed because in some instances one or more of the files is missing and if it's not a clean directory we get corrupt graphs with data collected from different days.
So basically what it needs to do is go to c:\temp and erase *.cap and N1*.txt
Thanks :o)
AidanEnos