I suppose the simple answer is that if you don't, then you don't get a slash generated. \ is a special character in the Format function. Details herewhy double slashes
Then the simplest way would be to split my statement and use two Format() functionsIn above code Recon is a folder name, if I want to pass variable in its place say ------> " & str_Recon & "
Format(Date, "yyyy\\m. mmm yyyy\\") & strRecon & Format(Date, "\\dd.mm.yyyy") & "\abc.xlsx"
Probably a little more confusing to read, but you can shorten that code snippet to this...Maybe something like the below, not sure if you need "9.Sep 2020" or "9. Sep 2020" with a space after the Month number
VBA Code:Format(Date, "yyyy") & "\" & Format(Date, "m. mmm yyyy") & "\Recon\" & Format(Date, "dd.mm.yyyy") & "\abc.xlsx"
Format(Date, "yyyy\\m. mmm yyyy""\Recon\""dd.mm.yyyy""\abc.xlsx""")