VBA File Search Inquiry

[Pinaceous]

Hi All,

Is it possible to perform a file search upon a unknown directory but in only knowing part of it?

For example; if FileA.xlsm is located in :=

C:\Users\Company\FolderA\Folder1\FileA.xlsm

Can a VBA File Search be performed upon FileA.xlsm if you provide:

C:\Users\Company\

Where the VBA code will search its folders until FileA.xlsm is found?

Kindly, let me know as I am very interested in this concept.

Many thanks in advance!

Respectfully,
pinaceous

 

[Pinaceous]

Hi All,

Is it possible to perform a file search upon a *known directory but in only knowing part of it?

For example; if FileA.xlsm is located in :=

C:\Users\Company\FolderA\Folder1\FileA.xlsm

Can a VBA File Search be performed upon FileA.xlsm if you provide:

C:\Users\Company\

Where the VBA code will search its folders until FileA.xlsm is found?

Kindly, let me know as I am very interested in this concept.

Many thanks in advance!

Respectfully,
pinaceous



*Sorry I meant to say known directory.