ExcelBanter - Automatically printing to PDF with the filename as the sheet name

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Automatically printing to PDF with the filename as the sheet name (https://www.excelbanter.com/excel-discussion-misc-queries/146115-automatically-printing-pdf-filename-sheet-name.html)

Lee Crew

Automatically printing to PDF with the filename as the sheet name

Hi I have Acrobat Distiller to print to PDF

I have say 5 sheets, (Eg Sheet1, Sheet2,Sheet3,Sheet4 and Sheet5)

Ho would the code work to automatically print each sheet to a separate PDF
with the PDF file name to be the Sheet name.

Any help would be greatly appreciated.

Thanks
Lee

All times are GMT +1. The time now is 09:52 PM.