Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel vba copy files
Hello,
I have a two columns : one with the path and one with the file name. Can anyone show me how to create a macro that copy those files to C:\Temp So for each file (column B), it will use its path (column A) and makes a copy of that file to C:\Temp until all the files have been copied. Thank you in advance Gabriel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel vba copy files
You can use FileCopy
You can loop through the list If you need help post back Sub A() With Sheets("sheet1") FileCopy .Range("A1").Value & .Range("B1").Value, "C:\" & .Range("B1").Value End With End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Gabriel" wrote in message om... Hello, I have a two columns : one with the path and one with the file name. Can anyone show me how to create a macro that copy those files to C:\Temp So for each file (column B), it will use its path (column A) and makes a copy of that file to C:\Temp until all the files have been copied. Thank you in advance Gabriel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Codes needed to copy same one row from more than 300 Excel files | Excel Discussion (Misc queries) | |||
How to MATCH or VLOOKUP & copy using 2 excel files | Excel Worksheet Functions | |||
How to lock Excel files so that others can copy it & not chg it. | Excel Worksheet Functions | |||
Macro to copy range from Excel files in folder | Excel Discussion (Misc queries) | |||
indirect copy protection of Excel files | Excel Programming |