ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,284
- Office Version
- 2007
- Platform
- Windows
Hi,
In my code the pdf file is saved using this partial piece of code.
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.
But the output is saved like so
JOE BLOGGS
24-10-2023195AC
B.pdf
Do you see why please.
Thanks
In my code the pdf file is saved using this partial piece of code.
Rich (BB 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.
Rich (BB code):
& .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