Open an excell file or text file or pdf from anywhere in the system

Hai dear friends

I have got a simple following macro to open an excel file by giving the entire path name in cell B4 ,if i change the path name ,the respective file name will open

Please Login or Register  to view this content.

in cell B4 I give like C:\TEST\User Report\LN167.xls

here is there any way just to give any file name with out giving the entire path and not only excel but any kind of filename also in cell B4 and get it open
for example in this case in cell B4 I give only LN167 or any other file name also like any pdf or any text or any picture file etc and get it open

thank you very much

Hello catchnanan,

With the exception of system files, any file that does not include a path is assumed to be in the current directory. It would not be practical to write a macro that would search the system to locate a file.