Excel PDF Macro

[JFORTH97]

Hi, Looking to use a Macro in excel that you press a button and saves document as PDF but the file name needs to be: Cashing Up Week End (Cell N4) which is a date

Hope someone can help!

Thanks

 

[John_w]

Try this - change the date format in the code as needed.

Public Sub Create_PDF()
    With ActiveWorkbook
        .ExportAsFixedFormat Type:=xlTypePDF, Filename:=.Path & "\Cashing Up Week End " & Format(Range("N4").Value, "YYYY-MM-DD") & ".pdf", _
            Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False
    End With
End Sub