Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
file search or search files | Excel Discussion (Misc queries) | |||
Search a FAQ file | Excel Worksheet Functions | |||
Turning a text file name into a search and linking the file as a hyperlink | Excel Discussion (Misc queries) | |||
File Search | Excel Programming | |||
Macro to search from one file & place on another file. | Excel Programming |