Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why is Word, Excel saving a backup copy in my temp directory? | Excel Discussion (Misc queries) | |||
Excel should let me sort the file directory when saving a file | Excel Discussion (Misc queries) | |||
Excel Slow File Open Directory Response | Excel Discussion (Misc queries) | |||
How do I insert the directory path in my Excel file? | Excel Worksheet Functions | |||
How do I force an Excel macro to ask me which file and directory? | Excel Discussion (Misc queries) |