Macro to print multiple worksheets to multiple PDFs.

Hello to all...any help on this subject is greatly appreciated...

I have a workbook that has about 25 worksheets. I need a macro that will convert each worksheet into its own separate PDF and saves it based on the worksheet/tab name. So, I would like to run a macro that when ran, will create 25 PDF files in a location of my choice, where each PDF filename is automatically generated in the form of WORKSHEETNAME_DATE.

I have a current macro that will print one or multiple worksheets into a single PDF, so I feel like I am close...here is the current code that I have...

Please Login or Register  to view this content.

That code references a function called RDB_Create_PDF...here is the code for that function...

Please Login or Register  to view this content.