My first post and I can answer some of the question, I run a macro that does that plus other things, hopefully I have pulled out the relevant bits.
Sub SavePDF()
Dim filename As String
Dim Path As String
' Print WorkSheet
'ActiveWindow.SelectedSheets.PrintOut Copies:=2, Collate:=True, _
'IgnorePrintAreas:=False
'Save PDF Copy, I am saving the file using date,no. and name which I have concatenated to a hidden cell (Cell#)
Path = "C:\PATH\"
Application.DisplayAlerts = False
filename = Range("Cell#").Value & ".pdf"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, filename:= _
Path + filename, _
Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=False
End Sub
Hope you find the answer to the other elements of your request.
Bookmarks