Creating Workbook in specific folder

[Szwadron6]

Hi,

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

U:\Urlopy\Manager

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

U:\Urlopy\Manager\Sky

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

U:\Urlopy\Manager

and its name include the required subfolder name.

    LWorkbook.SaveAs Filename:="U:\Urlopy\Manager\" & worksheets("Plik roboczy").Range("M8).Value & "Wniosek urlopowy " & Worksheets("Plik roboczy").Range("M10").Value, FileFormat:=52

Could I please ask for your help?