A way to print to pdf every tab of Workbook?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


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?action=getinfo&userid=10848
View this thread: http://www.excelforum.com/showthread.php?threadid=573974

.

Relevant Pages

  • Creating "Fill-In" type fields in Word 2003
    ... Using Word 2003 sp2 in Windows XP sp2. ... I've been asked to use a PDF file with heavy tables/lines and limited text ... I tried a "Text Form Field" but that's based on the formatting of the ... document text (It seems I have to put it on a line, and hitting 'Tab' simply ...
    (microsoft.public.word.newusers)
  • RE: Format changes after document is e-mailed
    ... Setting up as a .pdf file is an excellent suggestion. ... advice about setting one tab for the positions. ... insert a right tab at the right margin. ... Lene Fredborg - Microsoft MVP (Word) ...
    (microsoft.public.word.pagelayout)
  • A way to print to pdf every tab of Workbook?
    ... I'm using Adobe PDF Professional and my simple macro ... single pdf file. ... for each tab in order. ...
    (microsoft.public.excel.misc)
  • Custom properites in PDF files....
    ... I have a word document which has custom file ... When I convert this to PDF file I am loosing this TAB. ...
    (microsoft.public.word.conversions)
  • Custom properites in PDF files....
    ... I have a word document which has custom file ... When I convert this to PDF file I am loosing this TAB. ...
    (microsoft.public.cert.exam.mcad)