using VBA to create the path and table name for pdf output files

[DBinPhilly]

Us the built-in PDF facility

Const Filepath = "C:\Users\bob\Documents\"

    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
                                    Filename:=Filepath & "myFile.pdf"

Thank you. Just what I needed.