Need to find a specific folder by its name

[necalabria]

Hello Everybory:

As the title says, I need to find a folder by its name in order to get its path, that is becauce I am coding an app to be used by many computers.

With some help from http://www.exceltrick.com/formulas_m...-dir-function/ I tryed to get that done with the below code I adapted from.

It just does not work. It gives the subfolders of "C:\Users\", but I can not make it to see if the subfolder I am looking for is in one of those in "C:\Users\".

Any help would br appreciated, I have been hardly working on this, with no success at all.

Thank you,

Nelson

[Logit]

Please Login or Register  to view this content.

[Arkadi]

is the folder always located in the c:\users\username folder?
If it is just that the username is different for each, but the relative folder location is the same then you could simply use something like:

Please Login or Register  to view this content.

[necalabria]

Hello Logit,

Thank you for your response.

Your code works, but I need to find the folder in the run, not by making a choice in a dialog box.

I have tryed to adapt your code to do it so, but I could not code to loop all and each one of the folders in "C:\Users\" looking for the one I need.

Thanks a lot anyway.

Nelson

[necalabria]

Great!

Arkadi's code did the job.

Thanks to Arkadi and Logit.

Nelson

[Logit]

Glad you have it working !

[Arkadi]

Glad we could help