Macro that processes subfolders

Might of been someone on this forum came up with this macro for me (GREATLY APPRECIATED) many years ago. I rarely use excel stuff other than for simple things. So I don't know the first thing about Macro code. We get updated price pages from our supplier each season and then we have to update two fields in each spreadsheet, several hundred pages scattered across several directories. This code works great, but I have to modify the directory each time. Is there a way to modify this code to not only process the directory, but all the subdirectories?

THANKS

Please Login or Register  to view this content.

You can use the 'Office.FileSearch' method.

I have a copy of the WROX book 'Excel 2002 VBA Programmers Reference' that shows how.

Please Login or Register  to view this content.

Hope this helps.