Creating Workbook in specific folder

Hi,

I want to use VBA to create a new workbook from the specific sheet in another workbook and save it in the location

Please Login or Register  to view this content.

but in that folder, there are multiple subfolders with a specific name. I want to create this new workbook in the subfolder which name I include in the original workbook in sheet "Plik roboczy" in cell "M8".

For example if in Cell M8 Value is 'Sky' I want to create the file in the path

Please Login or Register  to view this content.

I created the below code but it does create the workbook in the path

Please Login or Register  to view this content.

and its name include the required subfolder name.

Please Login or Register  to view this content.

Could I please ask for your help?

Looks like you're missing a folder separator after the subfolder. Perhaps:

Please Login or Register  to view this content.