ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,199
- Office Version
- 2007
- Platform
- Windows
Hi,
Something simple but its got me.
Currently the saved PDF file is as follows JUNE 06 2021 (2) BUT i would like it to be saved as 06 JUNE 2021 (2)
This is the line of code in use.
On my worksheet i have the following from where the values are taken from.
A3 = JUNE
D3 = 2021
E3 = (2)
Something simple but its got me.
Currently the saved PDF file is as follows JUNE 06 2021 (2) BUT i would like it to be saved as 06 JUNE 2021 (2)
This is the line of code in use.
Rich (BB code):
strFileName = "C:\Users\Ian\Desktop\GRASS CUTTING\CURRENT GRASS SHEETS\INCOME 2021-2022\" & Range("A3") & " " & Format(Month(DateValue(Range("A3") & " 1, " & "2021")), "00") & " " & Range("D3") & " " & Range("E3") & ".pdf"
On my worksheet i have the following from where the values are taken from.
A3 = JUNE
D3 = 2021
E3 = (2)