ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   A way to print to pdf every tab of Workbook? (https://www.excelbanter.com/excel-discussion-misc-queries/106293-way-print-pdf-every-tab-workbook.html)

MACRE0

A way to print to pdf every tab of Workbook?
 

I'm using Adobe PDF Professional and my simple macro
' ActiveWorkbook.PrintOut Copies:=1, Collate:=True "
which I'm 99% worked to print every tab in order of appearance to a
single pdf file. Anyhow it doesn't work now for some reason and I was
hoping someone would have a suggestion or have a different way of
attacking the problem. The macro currently creates multiple PDF files
for each tab in order. I have way to many tabs to splice them together
and too many to list. Any help would be greatly appreciated,

Thanks.


--
MACRE0
------------------------------------------------------------------------
MACRE0's Profile: http://www.excelforum.com/member.php...o&userid=10848
View this thread: http://www.excelforum.com/showthread...hreadid=573974



All times are GMT +1. The time now is 11:37 PM.

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