LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
file search or search files Richad Excel Discussion (Misc queries) 0 October 22nd 09 07:56 PM
Search a FAQ file Jane Excel Worksheet Functions 1 October 18th 06 09:07 PM
Turning a text file name into a search and linking the file as a hyperlink AlistairM Excel Discussion (Misc queries) 1 January 26th 06 04:55 AM
File Search unplugs[_48_] Excel Programming 1 August 8th 04 02:12 PM
Macro to search from one file & place on another file. Luong[_2_] Excel Programming 0 May 6th 04 04:53 PM


All times are GMT +1. The time now is 06:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"