Hello )

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 )

AidanEnos