Print Several Pages as One Job?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard Fry - 08 May 2004 12:07 GMT

Is it possible by some means (add-on?) to select which pages of an Excel
2000 workbook you want to print, and then send them to a print driver as
one print job containing all of those pages?

The goal is to create a single PDF file with all the selected pages, or to
be able to send all those pages serially in a single fax transmission from
the PC.

Thanks,

Richard Fry (not a programmer)
Illinois - USA

Reply to this Message

Paul Cundle - 08 May 2004 13:31 GMT

When you say "pages", do you mean worksheets? If so, you can select as many
as you like by holding down control (to select them one at a time) or shift
(to block-select whole range of sheets) before printing.

However, Excel has a tendency to print multiple sheets as multiple jobs even
if you do select them all together - unless you are careful to ensure that
all print settings are exactly the same on each sheet. AFAIK, there is no
way around this problem.

Paul C,

Signature

> Is it possible by some means (add-on?) to select which pages of an
> Excel 2000 workbook you want to print, and then send them to a print
[quoted text clipped - 8 lines]
> Richard Fry (not a programmer)
> Illinois - USA

Reply to this Message

Richard Fry - 08 May 2004 13:41 GMT

Thanks for your comments. Yes, I mean worksheets. I have tried selecting
the sheets I want as you suggest, but when sending them to my PDF print
driver the sheets are saved as individual files (1 per sheet).

The workaround is to combine the separate PDF pages/files into a single PDF
file using Acrobat, but that is rather a pain. I am looking and hoping for
a better solution.

R. Fry
__________________

> When you say "pages", do you mean worksheets? If so, you can select as many
> as you like by holding down control (to select them one at a time) or shift
[quoted text clipped - 4 lines]
> all print settings are exactly the same on each sheet. AFAIK, there is no
> way around this problem.

Reply to this Message

Paul Cundle - 08 May 2004 23:43 GMT

Hmm. As I say, the way you are doing it is technically correct but Excel is
a real pain when it comes to printing and likes to send pages separately. I
had a similar problem to you about a year ago (I wanted a document to be
stapled automatically, but the printer/stapler was handling each page
separately) and found no absolute solution, and have been monitoring this
newsgroup since with no further luck.

The closest I can offer is what I suggested before: give all of the
worksheets the same print settings and pray. This means things like paper
size and orientation, draft/black and white, and even such settings as
margins, gridlines, row and column headings etc might be relevant (though
possibly not).

Someone else here might have the answer, but if not and you do come up with
anything, please let us know.

Paul C,

Signature

> Thanks for your comments. Yes, I mean worksheets. I have tried
> selecting the sheets I want as you suggest, but when sending them to
[quoted text clipped - 17 lines]
>> careful to ensure that all print settings are exactly the same on
>> each sheet. AFAIK, there is no way around this problem.

Reply to this Message

Richard Fry - 09 May 2004 12:24 GMT

Thanks for your follow-up msg below. I am coming to the same conclusion as
you how about Excel can (not) provide this rather fundamental need. Excel
is capable of some very complex operations, but apparently not this simple
one.
___________________

Paul Cundle wrote...

> Hmm. As I say, the way you are doing it is technically correct
> but Excel is a real pain when it comes to printing and likes
> to send pages separately...

Reply to this Message

Alan - 10 May 2004 04:25 GMT

> Thanks for your follow-up msg below. I am coming to the same
> conclusion as you how about Excel can (not) provide this rather
> fundamental need. Excel is capable of some very complex operations,
> but apparently not this simple one.
> ___________________

I haven't got Adobe Acrobat so I cannot try it, but how about using
the report manager functionality?

Would that ensure a single PDF file?

Alan.

Reply to this Message

Rate this thread: