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

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?

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

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.


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"pokdbz" wrote in message ...
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?