Locate a File within a Directory's Folders

[toocold]

Carrying on with the same theme, what if I wanted to get the name of a folder where a specific file is located. I.e. The user picks one of the files and then it gives just the name, not the path.

[shg]

I don't know the theme you're referring to, but you could write code around Application.FileSearch. There are good examples in Help.

[Leith Ross]

Hello toocold,

Here is macro that will find a file among the folders in the parent directory and return the name of folder the file is in.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[shg]

Nice code, Leith.

It doesn't seem to search lower then one level below the current directory. Modify it to do so?

[Leith Ross]

Hello SHG,

Thanks. I'll work on a recursion routine to search all subfolders within a given directory for a file. It would be a good tool have. Thanks for the suggestion.

Sincerely,
Leith Ross