Macro to open a workbook from an unknown file path

Please can someone provide me with a macro to do the following:

Find a file (say test.xls) from a unknown file path (say in a subdirectory on C:/ drive)

Thanks

Patel45. Still having trouble with this one.

Macro seems to stop on Set objFSO = CreateObject("Scripting.FileSystemObject")

Any suggestions why??

Ahhh finally got it working. Seems issue is that it can search one subdirectory deep. Is it possible to modify it to search through say 4 tiers for subdirectories? Thanks for your help.

Thanks very Patel45. That works great now. Is it possible to add the following step too.


Say cell B4 in the original spreadsheet (where this macro is located) is the name of a macro in the newly opened spreadsheet. I need to run this macro and then copy data (say cell B5) from the original spread sheet into the newly opened spreadsheet (say into cell A1)

Hope that makes sense. Thanks again