Can you copy a Excel file to a new directory and rename it?

[Guest]

What I want to do is have an Excel sheet with file names in it. Like
Tester.xls in a cell

Then a macro that does this.
From those file names I want to make a new Exel file with the data from the
file.
Change the new file name.
Insert a picture into the first line

The files will be in the same directory they will just have different names.
I want the macro to do this for every file name. Is this possible?

 

[Ron de Bruin]

Make a copy of the folder and run this macro to do what you want on that folder
http://www.rondebruin.nl/copy4.htm

You can change my example code to code that insert a picture.