VBA, Looping through directory with advanced filter

  • Hi Guys, I got the following code that does an advanced filter through a workbook and gets the results and puts to a new sheet in the workbook.
    Is there any generic code that could help me loop this code through a directory? Just to make the process faster if I have 20 files or so.
    I have tried the ones online and can't seem to get them to work.

    Here is my code(ignore my notes, some are just so I can tell whats going on):

    any help would be appreciated. Thanks.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!