+ Reply to Thread
Results 1 to 5 of 5

Copy certain files from Source folder to Destination folder

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Copy certain files from Source folder to Destination folder

    Hello:

    I have 2 folders, C:\Source\ and C:\Dest\

    I need to copy certain files with below criteria from Source to Destination folder.
    Sheet1 cell K3 will have 1st 2 character to match.
    Example : K3 has character 03
    So need to copy all files from Source starting with 03 into Destination folder.

    Please let me know if you have any questions.
    Thanks.

    Riz

  2. #2
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Copy certain files from Source folder to Destination folder

    Hi,

    You can use this code :

    Please Login or Register  to view this content.

    Regards
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important

  3. #3
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: Copy certain files from Source folder to Destination folder

    Hi karedog:

    This code is copying all the files from source folder to destination folder.
    I need to copy files which starts will value what is in cell K3.
    Example:
    I have file in Source dir :
    01_2015_Andalusia_DailySales
    02_2015_Augusta_DailySales
    03_2015_Blakely_DailySales

    If K3 = 02 then need to copy only 02_2015_Augusta_DailySales



    Please let me know if you have any questions.
    Thanks.

    Riz

  4. #4
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: Copy certain files from Source folder to Destination folder

    Hi Karedog:

    Sorry it was my mistake...it works
    Thanks a lot

    Riz

  5. #5
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Copy certain files from Source folder to Destination folder

    You are welcome rizmomin, thanks for the reputation points.


    Regards

+ 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. Replies: 12
    Last Post: 03-09-2015, 05:52 PM
  2. [SOLVED] Copy List of Hyperlinked Files From Source to Target Folder
    By ugadawgs311 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 04-01-2014, 03:21 AM
  3. copying data from excel files in a source folder to target folder
    By Javed07 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2013, 04:27 PM
  4. [SOLVED] VBA Code open files in folder, copy text to workbook-Next time folder opened copy only new
    By Bikeman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-02-2013, 07:59 PM
  5. When i Copy Folder to new destination i lose customised folder icon/picture
    By sternboy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-29-2012, 09:30 PM

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