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

[Bob Phillips]

Use the built-in PDF facility

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

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