Get folder path if you know folder name only

[Sahak]

Hi All,

How with VBA to get folder path if you know folder name only ?
For example if you know that somewhere in computer there is a folder named “Invoices_2019”
Thank you in advance

 

[mole999]

If it were below "Y our document s" then probably searchable, if it was in an unexpected place then how many iterations are you prepared to wait before a fail, given that the search term might not be exact

 

[Sahak]

Hi

Thank you very much for reply. The scenario is this:
There is a program made by Excel VBA for more than one user & database file located on SERVER, in folder “Invoices_2019“,so any user can use the same database file. It happens that the company changes server name or location, so in program I need to have a VBA code to find folder’s new location.

 

[mole999]

i did appreciate that,

 

[Sahak]

Sorry, I did not quite understand your reply, English is my 2nd language, is what I’m asking not possible?

 

[Sahak]

Hi,

I don't have a code, I ask for it from you guys. I need a code to find where is the new location of the folder “Invoices_2019“ on the network. Let say before it was on '\\ABCData\", and now it changed & it is in "\\ABCMainData\", so I'm looking for a VBA code to get "\\ABCMainData\".
Thank you in advance