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
Bookmarks