opening workbook found with Dir loop

I want to loop through workbooks found by the method below, opening each one so that I can search for and copy data in it.

Please Login or Register  to view this content.

I know it must be a problem with the path, but how do I change the path and still get the macro to loop through the "Dir" collection?
All suggestions appreciated!

Thanks,

willardio

Hi Willardio,

I think you should do it like this. Does it work?

Please Login or Register  to view this content.

Thanks gergo, that helped. It showed me that I had to append the path like so:

Please Login or Register  to view this content.

And thank you too Norie, I'm going to work that in.