I am currently using this code to find and copy selected files from the folder the workbook is saved in to a new folder:
Can this be extended to search for the file in all subfolders?![]()
Please Login or Register to view this content.
I am currently using this code to find and copy selected files from the folder the workbook is saved in to a new folder:
Can this be extended to search for the file in all subfolders?![]()
Please Login or Register to view this content.
Hi tryer
You'll need to do a "recursive" search. The technique is demonstrated in these two links
http://www.excelforum.com/excel-prog...ster-file.html
http://www.excelforum.com/excel-prog...orksheets.html
If you need help adapting let me know.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
thanks Jaslake, I did some searching and found some similar recursive loops, I'm currently working on adapting them, thanks for the offer of help, I'll certainly come back if I get stuck
Hi tryer
Glad you're running with it...success stories are my payback...good hunting. Keep me posted on your progress. Need help, please let me know.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks