Automatically copy file and create folder that...
Posted on 2006-03-29
I have a question and I really need your expertise as I don't know if I should use good old DOS or maybe visual basic! Ok, here's the scenario:
I have a software that automatically output a file, let say the name of the file is Report.xyz on daily basis. Everyday the Report.xyz get overwritten so what I want to do is the following:
I would like to save the copy of the file each day before it gets created and I thought that maybe I can create a batch that would look at the file then create a folder name with the date of the file and then copy the file to that folder? i.e.
Report.xyz was create on March 20, 2006 then create a folder called March202006 and copy the report.xyz to that directory.
Report.xyz was create on March 21, 2006 then create a folder called March212006 and copy the report.xyz to that directory.
Can this be done and how? Or do you advise that I use visual basic, access or something similar?