Hi Admin
First, I am very grateful for your help.
Second showed many examples only for this macro are able to find the root folder in my example State) and then find the folder Cities.
Ie I do not want to do things on my desktop, and make them in my chosen folder - automatic, ie a macro.
I say the macro works fine, but each folder look for her clicking until he came to it (it's in the second case).
Let's write it again:
You've got your desktop.
Of it (the desktop) you have 1 folder named countries.
in this folder countries have more than 70 folders with names of cities.
Problem: how like punched in sheet1 (activation of macro) automatically find the folder (countries)?
It should - according to the city from cell C5 in Sheet2 - automatically finds the city and remains only for me to write the title of the excel file!
I'm sure you can do it, the question is whether we can find the correct words