ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Print multiple worksheets into separate pdfs (https://www.excelbanter.com/excel-programming/392629-print-multiple-worksheets-into-separate-pdfs.html)

[email protected]

Print multiple worksheets into separate pdfs
 
I have an excel workbooks with multiple tabs (worksheets). Each
worksheet must be converted to a singular pdf file with a specific
name. Is there away to do this in a quick way without printing each
worksheet separately?

Thanks
Jessie


[email protected]

Print multiple worksheets into separate pdfs
 
On Jul 4, 7:05 am, wrote:
I have an excel workbooks with multiple tabs (worksheets). Each
worksheet must be converted to a singular pdf file with a specific
name. Is there away to do this in a quick way without printing each
worksheet separately?

Thanks
Jessie


Jessie,

Your PDF writer may allow you to put separate sheets to separate files
eg the free www.cutepdf.com PDF writer does this by default.

You'd then just group all your sheets together, then print selected
sheets to PDF and it'll ask you for a filename for each sheet (file)
created.

Regards

Jeff



All times are GMT +1. The time now is 04:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com