SubFolders in macro

[pianoman]

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

 

[Guest]

http://support.microsoft.com/kb/185476/EN-US/
How To Search Directories to Find or List Files

http://support.microsoft.com/kb/185601/EN-US/
HOW TO: Recursively Search Directories by Using FileSystemObject

http://support.microsoft.com/kb/186118/EN-US/
How To Use FileSystemObject with Visual Basic

 

[pianoman]

Thanks Tom... you're a wealth of useful info!

Ta,