Hi,

I have made a macro for a project which i am working on. I have to run this
macro every week on different files. These files have names which include the
date of the data. Now without overwriting this file i want to run the macro
but want the date of this file to be included in the final file which i have
made. Is there anyway to do this?



for eg: Data file : Name : ABC 10-3-06

i want the final output files name to be : XYZ 10-3-06



Can somebody please help me.

Aziz.