| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to display full file path name in Excel 2007 | Excel Discussion (Misc queries) | |||
| How do I get Office 2007 to show me the full path of a file? | New Users to Excel | |||
| Keep full file path in cell reference | Excel Discussion (Misc queries) | |||
| full path of excel file | Excel Discussion (Misc queries) | |||
| Getting the full path when from a File Open Dialog Box | Excel Programming | |||
Hybrid Mode
