Hi, at my job we have a big folder (CLIENTLIST) with subfolders for each of our clients. Within each client's folder there are subfolders for years, containing all the documents pertaining to that year for that client. Each year's subfolder has a file called "annual report." I'm trying to write a macro that opens up explorer, goes to the client's folder, searches through all the year subfolders for the annual reports, and shows the results. I've searched around quite a bit for help on how to do it, and this article was very useful:
http://www.excelforum.com/excel-prog...op-search.html
But when I copied the code from there (and adjusted it to my variables) I get a run error saying that " Windows cannot find ". " Any help would be appreciated. Here's my code:
**(obviously for the clientFolder variable uses the full path name, not "...")
Thanks for helping!
Bookmarks