Save Worksheets As New File To Specific Folder

[k0st4din]

No, no, no, no, my friend somewhere or confuse me or you.
I beg you make a folder on the desktop that says countries "do it 3 more folders 1st - London, 2 nd - Paris 3rd - Sofia.
Write in Sheet2 cell C5 eg London, go on Sheet1 press the button and let me jump out the window and ask for the name of the excel file and write something after clicking "OK" you should be able to see the excel file in a folder London, not elsewhere.
C \ Users \ .......... \ Desktop \ Countris \ - and get here already excel file are able to find the folder according to his city from cell C5
Beginning to despair!
Regards

[k0st4din]

Hello Mr. Admin,
we want to finish my problem?
I do not know if you know, but you're the only present that reached almost to the end!
Please help me!
Thank you again and again!

[Admin]

Hi

Sorry for the late reply. See Post # 2

[k0st4din]

Screen_06 Jun. 07 09.18.jpg
Screen_05 Jun. 07 09.17.jpg
Screen_03 Jun. 07 09.16.jpg
Screen_04 Jun. 07 09.16.jpg

The code works, but needs a little change. Please look at pictures or see post *11

[Admin]

Sorry, but I could not understand your query

I already provided 2 solutions, one, to select a folder via a dialog and the other one, folder with city name on the desktop.
Not sure what do you want now.

[k0st4din]

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

[Admin]

To save file in the country folder within folder 'countries' on desktop, try

wbkNew.SaveAs strDesktopFolder & "\Countries\" & strCity & "\" & strFName, 51

[k0st4din]

You are God, that's what I had in mind.
Now we knew Dear God (admin) could help me.
Here's where the problem was - I laid all the way to the folder and it should have and just put her name
Infinitely thank you Admin!
Thank you, thank you, thank you!

[Admin]

Thanks for the nice comments.