Livin404
Well-known Member
- Joined
- Jan 7, 2019
- Messages
- 743
- Office Version
- 365
- 2019
- Platform
- Windows
I have the generic code to save to PDF from Excel; I would love to put the julian Date at the end. In this case in would be "Inbound 156 23149" or whatever the current date is. If it is too difficult I can settle for the normal date 29 May 23 for example "Inbound 156 29 May 23".
Thank you,
Thank you,
VBA Code:
Sub save_for_Inbound_156()
'Create and assign variables
Dim saveLocation As String
saveLocation = "C:\Users\Whiteside\OneDrive\Desktop\Domestic\Inbound156.PDF"
'Save Active Sheet(s) as PDF
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=saveLocation
End Sub