+ Reply to Thread
Results 1 to 2 of 2

Copy file form folder & sub folders in VBA

  1. #1
    Registered User
    Join Date
    09-12-2019
    Location
    Bnagladesh
    MS-Off Ver
    2013
    Posts
    39

    Copy file form folder & sub folders in VBA

    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

  2. #2
    Registered User
    Join Date
    09-12-2019
    Location
    Bnagladesh
    MS-Off Ver
    2013
    Posts
    39

    Re: Copy file form folder & sub folders in VBA

    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.
    Last edited by Pepe Le Mokko; 11-17-2019 at 04:19 AM. Reason: Quoted response deleted containing comm links - User was banned

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA Module to copy all files from a folder and it's sub-folders into one location
    By X*DG^& in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-13-2019, 02:40 AM
  2. Replies: 3
    Last Post: 07-17-2019, 12:16 PM
  3. Different Hyperlinks as source folders to copy all files in new folder
    By mullean3 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2017, 09:55 AM
  4. Macro to crealte folders from excel file not creating folder with / in the name
    By Lohara005 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-22-2016, 11:57 AM
  5. [SOLVED] Search for file names in main folder and its sub folders
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-09-2015, 01:17 AM
  6. Looping File Movement From a Number of Folders to One Folder
    By jablo1312 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-15-2014, 09:48 AM
  7. Copy Files from one folder to different folders based on pdf file name
    By jtammyg in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-23-2014, 11:49 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1