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

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!

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

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

--
Regards,
Tom Ogilvy


"jim9912" wrote:

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!