MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Finding file

Posted by Mark on August 21, 2000 2:15 AM

Is there a code that will locate a file on a Drive.

I.e. like the "Find" button.

If so can it find it so the user has the option of opening it or deleting it.

Any help?


Posted by Mark on August 22, 0100 1:51 AM

Thanks a lot.

Is there a way it can do this automatically. Say you enter a file name and it searches it for you.


Posted by Tim Francis-Wright on August 21, 0100 10:17 AM

Check out Martyn's response to my similar
question at


(He showed me how to call the open file dialog
within an Excel workbook).