Specific File Search VBA script

[dcharland]

I need to help with a VBA Script...I've spent multiple hours reading the posts and trying them, but none actually worked or if they did I didn't know how to make them work!! I've create a few scripts but looping through directories will be a first for me

I would like to have a script that will use a base path E.i C:\temp\ and them read cell A1 for a subfolder name e.i. dir1 now within this dir1 there are multiple directories and I want to code to look through all of them for files that match the following criteria. (first character a number, second a letter and third a number, then 4 more characters or letters and finishes in .csv) once the criterias are matched then append the path and file name to column C. I have the script that will open the file and copy paste the info I need.

The idea of the script is that there are new files created every day and I want to be able to track the history of which files were imported into the master so that I don't need to re-import them all each day! As there could be a few hundred of them and it would take a long time to run the script.

Hope that makes sense? Any guidance is highly appreciated.

 

[brettdj]

Hi,

My Article here, "Produce an Excel list of the attributes of all MP3 files that sit in or below the "My Music" folder." http://www.experts-exchange.com/A_2839.html

It provides a recursive directory search, along with the use of Dir to only pull MP3 files

I'm tied up at present, let me know if you can adapt this to your needs, if not I will look at it in more detail when I can

Cheers

Dave

 

[dcharland]

Thanks,

I'll give it a go and let you know how it goes.

Denis