Copy Files From One Folder and Paste into another Folder

[jadown]

Hello Everyone,

I have no clue on how to code this. I can copy specific files from one folder to another by code. However, I have an Excel file with various source folder locations (column A), with the file names (column B), and the destination folder for the files to go (column C). I would like the code to loop through column A and copy that folder and paste it into the destination folder that's identified in that row in column C.


Thanks!

[Leith Ross]

Hello jadown,

Do you want to copy the folder's contents, files and subfolders, to the destination folder or do you want to copy the files in column "B" that go with the folder in column "A" to the folder in column "C"? A few examples would help.

[jadown]

I want to copy the contents of the source folders to the identified destination folder that's listed in column C.

Thanks!

[Leith Ross]

Hello jadown,

The macro should ignore column "B" and copy the source folder and all it's files and subfolders and their files to the destination folder in column "C". Is that correct?

[jadown]

Correct. I just want to copy of the contents in the source folder.

[Leith Ross]

Hello jadown,

This should work for you. The folders are assumed to start in cell "A1". Change this if needed.

Please Login or Register  to view this content.

[jadown]

It works!!! Thank you so much!

[Leith Ross]

Hello jadown,

You're welcome.