Hi Guys,
I need some code that will allow me to search a folder "Model1", an
it's subfolders "Vend1, Vend2, Vend3" etc. for the file "Risk Filte
VENDCODE latest.xls", open the file, copy some cells of the "Summary
sheet onto a master sheet, and then close the file and move on to th
next Risk filter file, which will be a different subfolder. I
possible, it would then move on to the next master folder "Model2".
can just run that as a different sub if needs be though...
I don't need to record the VENDCODE results or anything so a wildcar
there is fine, it's the subfolder searching that's getting me stuck.
can do all the workbook specific code... if anyone could supply th
looping subfolder searching bit, that would be excellent.

Thank you,

Garet

--
pianoma
-----------------------------------------------------------------------
pianoman's Profile: http://www.excelforum.com/member.php...fo&userid=3371
View this thread: http://www.excelforum.com/showthread.php?threadid=53713