MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Searching for filenames or FOLDERnames containing keyword using...

Posted by Chris on December 28, 2001 8:28 AM

Hi -

Using Application.Filesearch does a great job searching for specific filenames when I use it like this: .Filename = "*" & txtKeyword.txt & "*"

Does anyone know how I add code that gives me the option to search in the Foldername / Pathname also? (I am outputing my results to a list box by the way)


Posted by Chris on December 28, 2001 11:51 AM

got it! just had to use the LIKE operator and an extra IF statement. If anyone needs to do this let me know and I'd be glad to explain in more detail.