Saved file output not as i expected

[ipbr21054]

Hi,
In my code the pdf file is saved using this partial piece of code.

& .Range("B3").Value & " " & .Range("AB1").Value & " " & Format(.Range("E3").Value, "dd-mm-yyyy") & ".pdf"

The saved test file for the above is saved like so
JOE BLOGGS
195ACB
24-10-2023.pdf


Im trying to change the date & ref number around so it looks like this
JOE BLOGGS
24-10-2023
195ACB.pdf

So i used this line of code to replace the original.

& .Range("B3").Value & " " & Format(.Range("E3").Value, "dd-mm-yyyy")& .Range("AB1").Value & " " & ".pdf"

But the output is saved like so
JOE BLOGGS
24-10-2023195AC
B.pdf

Do you see why please.
Thanks

 

[duggie33]

You have a space ("& " " &") between the first and second values but not before the second and third values. Try below...

& .Range("B3").Value & " " & Format(.Range("E3").Value, "dd-mm-yyyy") & " " & .Range("AB1").Value & ".pdf"

I hope that helps,

Doug

 

[ipbr21054]

Many thanks that did the trick.

Have a nice day

 

[duggie33]

Glad to help. Thanks for the feedback.

Doug