Thread: File Search
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MD MD is offline
external usenet poster
 
Posts: 26
Default File Search

I'd like to know how to search for a known file (MyFile.pdf) that is located
somewhere in either on the C, D or E drive and get it's full pathname as a
string.
The end result would be:
MyString = "c:\MyDocuments\MyProgram\MySearch\MyFile.pdf" what is in quotes
would be the search results

Bonus Question
If more than one file is found, the one with the latest one would be date
would be returned.
************
or
************
If someone knows how to open a pdf file (MyFile.pdf) with Adobe Reader. Now
the folder that contains the exe reader is never in the same folder pending
on it's version and may be in other drive pending on the installation from
the user. So when I use the SHELL(path, filename) it doesn't always work.

Regards

Michel