Finding a file in sub folders and taking you to the location of searched file

• I have a couple of drawings in PDFs and .dwg file format .
• All files are stored in sub folders which are in turn saved in a folder; which sits in C:

I am trying to write a VBA program that requests you to enter the file name and then looks for it in each sub folder in the main folder.
When found, directly open up the location of the file., i.e , take me directly to where the file is .

I there a way to do it ?

Use the following code :
It just reports where the file is available. But does not open the location of the file .

Please Login or Register  to view this content.

Source for above code :
http://social.msdn.microsoft.com/For...subdirectories

how about this:

Please Login or Register  to view this content.

Hi,

please take care to enter the filename with the extension, e.g. "ss.txt"

"ss" will not be found.

Hi,

so you want to enter the file-name without extension, and only the following extensions will be taken into consideration: "dwg", "dwf", "pdf"
In case of a finding the folder will be opened and the file selected. The next step would be to implement the selection of the folder to start searching, or is it always the same?
Try: Book1.xlsm

code:

Please Login or Register  to view this content.

Originally Posted by subbby

1. ...
2. ...
3. copy the file from this folder onto another folder (Folder path- C:/Documents)
4. OPTIONAL : copy the file name onto a cell in an excel sheet

If you want to copy the file automatically and write the name (source and target folder too?) into the sheet, do you still want to open the explorer window?




This will not show the path in msgbox, still open the explorer, copy the file, write to sheet
Please change the target folder to be copied to in

Please Login or Register  to view this content.

# Book1.xlsm #

Originally Posted by tehneXus

If you want to copy the file automatically and write the name (source and target folder too?) into the sheet, do you still want to open the explorer window?

It need not open the explorer window .

in the The excel workbook you attached , is "M_STR_TARGET_PATH " the target folder and "FindFileInFolder" the folder in which it searches for the user given file name ?

I tried to run with my paths. It gave me permission denied and highlighting the following :

Please Login or Register  to view this content.

There is a backslash missing at the end of "M_STR_TARGET_PATH", which is the target folder

If this will not solve your problem try this:

Please Login or Register  to view this content.

The following line lists the extensions to look for, just add/remove whatever you want:

Please Login or Register  to view this content.

Originally Posted by tehneXus

The following line lists the extensions to look for, just add/remove whatever you want:

Please Login or Register  to view this content.

The first thing I did was trying that . It said "FILE NOT FOUND"

let me try again.

To ignore the case of the extension use:

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

Please Login or Register  to view this content.

should not be commented ^^

USE:

Please Login or Register  to view this content.

please check if this runs faster and finds "*.idw" files.

Please Login or Register  to view this content.