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