+ Reply to Thread
Results 1 to 2 of 2

Search Folders and Return Copy files matching multiple criteria

  1. #1
    Registered User
    Join Date
    07-09-2010
    Location
    Denver, Colorado
    MS-Off Ver
    Excel 2007
    Posts
    32

    Search Folders and Return Copy files matching multiple criteria

    Hello again,

    I've modified some code that searches folders and subfolders and copies files into a new folder. With small directories the code works well, however I need something much faster than can search through nearly a terobyte of excel files. Second, I need to be able to paste a list of numbers instead of the current Search Criteria 2 that allows for one entry. The macro should loop through through all folders one time returning all matches for search criteria 1 and the listed Criteria 2. I attached an example workbook.

    Any advice is most appreciated!!!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    07-09-2010
    Location
    Denver, Colorado
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: Search Folders and Return Copy files matching multiple criteria

    Or is there a way to limit the file search from folder names containing numbers 10000 to 10156, for example?

+ 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