Macro to search for a file and return it's full path

[jim9912]

Is there a way to (using an escel VBA macro) search for a filename and
return its path? THe file I am looking for will always be the same,
but could have a different path from machine to machine.


THanks!

 

[Guest]

http://support.microsoft.com/kb/185476/EN-US/
How To Search Directories to Find or List Files

http://support.microsoft.com/kb/185601/EN-US/
HOW TO: Recursively Search Directories by Using FileSystemObject

http://support.microsoft.com/kb/186118/EN-US/
How To Use FileSystemObject with Visual Basic