Take a look here....Conan just helped me with a similar request. I'm using
2003 and it works great.

http://www.microsoft.com/office/comm...a-b2d2523a7cf2

HTH,

Don

"QuietMan" wrote:

I trying to search a specified directory for the location of a specific file
Once the file is found I want to be able to return that directory and path
so i can use it in other parts of of the macro

Thanks


--
Helping Is always a good thing