+ Reply to Thread
Results 1 to 2 of 2

VBA Macro: Exclude certain files and folders during a recursive search

  1. #1
    Registered User
    Join Date
    10-17-2018
    Location
    Frankfurt, Germany
    MS-Off Ver
    MS Office 2013
    Posts
    5

    VBA Macro: Exclude certain files and folders during a recursive search

    Hello everybody,
    i've some struggle with my VBA code and i hope some of you can help me with that.
    My macro should search from a directory all files that match my search criteria and copy a specific section from that files into my main excel file, fortunately this works fine.
    Unfortunately there're some files that have the same name and i want to exclude every file from my search that contains the word "archive".
    This is the code at the moment and i really don't know how to implement that.
    If anyone could help me with this, i would be really happy!


    Please Login or Register  to view this content.
    Greetings

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: VBA Macro: Exclude certain files and folders during a recursive search

    Try changing this part of your code:


    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

+ 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: 5
    Last Post: 11-02-2018, 03:15 AM
  2. [SOLVED] Recursive List Folder include hidden & system folders and files
    By CobraLAD in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-07-2015, 03:45 PM
  3. Macro to search files names and sub-folders
    By sambo24 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-12-2015, 10:18 AM
  4. Search Folders And Create Hyperlinks To Files
    By hate0lif3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-21-2014, 05:17 AM
  5. Replies: 0
    Last Post: 05-26-2014, 07:47 PM
  6. [SOLVED] Search for files in folders and subfolders
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-16-2014, 08:43 AM
  7. Search data in files and folders
    By Remphan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-16-2013, 07:22 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