Printing Active Sheets to a PDF File
Peter Boekelheide via AdminLife
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?
--------------------------------
From: Peter Boekelheide
-----------------------
Posted by a user from AdminLife (http://www.adminlife.com/)
<Id>pLFDP2CWokWFc1Zae2cCmw==</Id>
Paul Cundle
http://tinyurl.com/4394g
and looking at the links contained therein. I think you're going to be
disappointed.
Paul C,
--
BowMag
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...
David A. Smith
> (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...
Gord Dibben
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
Alan
news:b790p0llbtht8ls6k...@4ax.com...
>
> David
>
> 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
I just installed Adobe Acrobat Prof. 6.0, and it also appears to have
problems with printing multiple
excel active worksheets to a .pdf file. Amazing... this is the latest and
greatest Adobe product and it screws up
on apparently one of the most common printing tasks an excel user has.
However, I found your note to David at this ng
and I used your recommended method of printing to a .ps file. While I have
ghostscript and GSview, the
recently installed Adobe grabbed the file extension association for .ps. I
doubled clicked on the .ps file and the newly
installed Distiller made the conversion just fine. thanks for the excellent
pointer.
T-REX
"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:b790p0llbtht8ls6k...@4ax.com...
rob621
This is what worked for me...
FILE>Page Setup
Options...
This opens Adobe PDF Document Properties
"Edit"...Default Settings
This opens (on my computer) "Standard Adobe PDF Settings"
On the drop down list change "compatability" to Acrobat 7.0 (PDF 1.6)
or whatever version you are running.
--
rob621
rob621
rob621;7523009 Wrote:
> This is what worked for me...
> FILE>Page Setup
> Options...
> This opens Adobe PDF Document Properties
> "Edit"...Default Settings
> This opens (on my computer) "Standard Adobe PDF Settings"
> On the drop down list change "compatability" to Acrobat 7.0 (PDF 1.6)
> or whatever version you are running.
You must have PDF selected as the printer otherwise different dialogue
boxes appear
--
rob621