Copy file form folder & sub folders in VBA

**mehidy1437** · 11-16-2019, 09:59 AM

Hi Guys,
I have a file named color_details.xls with others xls file, in a folder called "sample", inside this folder there is another 3 folder & inside these 3 folder there are some more folder.
I have the color_details.xls with others xls, in almost all the folder.

Some times in some folder this file can be missing also.

What i want is, I will make "colordetails" folder in main folder called "sample" and copy only color_details.xls file with rename to avoid over written.

How can i do this in VBA?

folder.jpg

**mehidy1437** · 11-16-2019, 10:26 AM

Thanks for your response, but this is not what I'm looking for.
I am trying to copy only a specific named file from each folder, and paste them in a new folder with a new name to avoid over written the file.

Copy file form folder & sub folders in VBA

LinkBack

Thread Tools

Rate This Thread

Display

Copy file form folder & sub folders in VBA

Re: Copy file form folder & sub folders in VBA

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA Module to copy all files from a folder and it's sub-folders into one location

[SOLVED] Extract Folder, sub-folders and File name from one column to multiple columns

Different Hyperlinks as source folders to copy all files in new folder

Macro to crealte folders from excel file not creating folder with / in the name

[SOLVED] Search for file names in main folder and its sub folders

Looping File Movement From a Number of Folders to One Folder

Copy Files from one folder to different folders based on pdf file name

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions