Thread: Macro to search for a file and return it's full path
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 6,953
Default 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!


Reply With QuoteReply With Quote