Hi

I am at a loss for a code that will search for an excel workbook beginning with (whatever), in a folder and the folders sub folders, and open the file.
I know the starting directory eg (C:\Users\)

I am using excel 2010 and have previously used application.filesearch which no longer works.

Any help would be appreciated.

thanks