View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jgrob3@hotmail.com is offline
external usenet poster
 
Posts: 6
Default 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