Thanks in advance for the help. I need to save a worksheet in the Active workbook path as a PDF. I further need to name the worksheet by the Active Workbook name followed by "settlement letter"

So far, my macro saves the active sheet as a pdf in the Active workbook directory with the file name "Settlement Letter.pdf" but I don't know how to add the workbook name in front of the title.

If the name of the workbook is "Smith-1034" I would want the output to be "Smith-1034 Settlement Letter.pdf"

Any ideas? Here's the code I have.

Please Login or Register  to view this content.