+ Reply to Thread
Results 1 to 3 of 3

Search and Copy files from a list of file names excel vba programming

  1. #1
    Registered User
    Join Date
    01-21-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    1

    Search and Copy files from a list of file names excel vba programming

    Hi,

    I have a list of 500 file names , each 12 digit without extension ( can be either .doc or .pdf) in a excel sheet. There is a directory that contains around 15000 files also containing these 500 files.

    I want to search by these file names in the directory and copy these files to another location if found. (There can be two files by the same name one .doc and another .pdf. ). I would want to copy them both in that case !

    Can anybody please help me with this ?


    Thanks in advance !!

    Aashish

  2. #2
    Valued Forum Contributor
    Join Date
    05-14-2009
    Location
    gold coast
    MS-Off Ver
    Excel 2007
    Posts
    843

    Re: Search and Copy files from a list of file names excel vba programming

    Hello

    assuming that the filenames are all in one column and contain the whole file path and name with extention. if not add the source folder in 1st part of the file copy.
    Please Login or Register  to view this content.
    hope this helps


  3. #3
    Valued Forum Contributor
    Join Date
    05-14-2009
    Location
    gold coast
    MS-Off Ver
    Excel 2007
    Posts
    843

    Re: Search and Copy files from a list of file names excel vba programming

    revised
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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