File Copy from paths specified in columns.

Hi,

I am having trouble with VBA code that is intended to Copy from Column A (Named Range: Source_List) to destinations set in Column B (Named Range: Destination_List)

My current code was adapted of a file copy script, but as I am new to coding I have most likely not addressed the procedure correctly.
The next stage in the code is to have the msgbox report which files have been moved.

Any help is greatly appreciated.

Possibly...

Please Login or Register  to view this content.

Hi and thank you for the response.

Unfortunately, the code is returning a runtime error.

Can you show the error message and the line of code that highlights with the error?

Hi and thank you for continuing to help.

Invalid procedure with: .copyfile cell.Value, cell.Offset(, 1).Value, True 'Warning: set to overwrite existing files

Try this - again remembering that it will overwrite existing files in the destination folder.

Please Login or Register  to view this content.

Hi, is there an option to rename file instead of overwriting the file ?
For example :
I have files - Test_A.pdf Test_B.pdf .........
Start macro to copy them, but the Test_B file is already in the destination folder.
It is possible for the macro to rename the file to "Test_B (2).pdf" or "Test_B (3).pdf" ... (4).pdf ... ( it depends on how many copies are already in the destination folder ) and copy this new renamed file ?