VBA Code to print a worksheet from Excel to a pdf and place in a folder

[maryren]

Hi,
I know this is possible, just don't know how to write it. I need to print a worksheet from an excel file to a pdf and file it in a specific folder. The name of the worksheet (for an example) can be called PRINT PDF and the name of the folder could be EXCELPDFFILES. Hoping someone can help me with this.

[GooberTron]

To save the currently active sheet as a PDF you could use something like the following in code. Hopefully it is obvious that you can modify the constants at the top to suit your filepath and filename;

Sub SaveAsPDF()

Const FILEPATH As String = "C:\Users\MaryRen\Desktop\Test\"
Const DOCNAME As String = "mypdf.pdf"

    ActiveSheet.ExportAsFixedFormat _
    Type:=xlTypePDF, _
    FILENAME:=FILEPATH & DOCNAME, _
    Quality:=xlQualityStandard, _
    IncludeDocProperties:=True, _
    IgnorePrintAreas:=False, _
    OpenAfterPublish:=False
    
End Sub

[maryren]

Perfect, thank you.