--------------------------------
From: Peter Boekelheide
-----------------------
Posted by a user from AdminLife (http://www.adminlife.com/)
<Id>pLFDP2CWokWFc1Zae2cCmw==</Id>
Paul C,
--
I had the same problem. I now use a pdf program called WIN2PDF and simply
select the worksheets I want and print to the win2pdf 'printer'. Works
every time.
access them at http://www.win2pdf.com/
BowMag
"Paul Cundle" <ne...@cundle.co.uk> wrote in message
news:eoV5m6Sj...@TK2MSFTNGP10.phx.gbl...
> (Type your message here)
> I've got a user that wants to print only certain sheets to a single PDF file using
> the Adobe PDFWriter. However, when he selects the sheets he wants and
> goes to print them to the writer with the "Active Sheets" radio button checked,
> it does not work. Instead of printing one PDF file with all sheets inside it in
> makes several PDF files, each one sheet. Is the only way around this to then
> merge the three together afterwards?
I found a fix to this problem, that works in Office 2000 anyway...
Each worksheet is created from a single worksheet.
Right click on the target worksheet, "Move or Copy", check "Make a Copy".
DON'T Insert->Worksheet.
DON'T populate more than a single worksheet that is to be printed from the
auto-generated ones.
Then format away. The result for me was a five page, single pdf, three
pages portrait, and two pages landscape (with graphics). Before applying
this trick, I had three individual pages (each as their own pdf) and a pair
of pages that had been copied one from the other (which was the clue)
Yes, it is a pain in the tush to copy the contents and the column widths
from existing spreadsheets, but it does pay off...
Less pain in the tush.............
I have had success with the free file downloads and instructions for use here
at Dale Nurden's site.
http://www.rcis.co.za/dale/info/pdfguide.htm
Saves first to single *.ps file which is then converted to *.pdf
Returns one PDF file from multiple sheets.
Gord Dibben Excel MVP
This is possibly even less of tush issue:
D:\Programs\GhostScript 8.14\FreeDist v3.0\FreeDist - Info Page.mht
This will append multiple PDFs into one and doesn't even require
installing. It works great for me under Win2k Pro so it should be
fine for WinXP too I guess.
There is also some sample excel VBA code at the bottom of that page,
but I have never bothered to use it - I just create the PDFs normally,
then append each of them to the first.
HTH,
Alan.
T-REX
"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:b790p0llbtht8ls6k...@4ax.com...
--
rob621
You must have PDF selected as the printer otherwise different dialogue
boxes appear
--
rob621