printing multiple copies of a worksheet

[bloodgroove]

I spent the last 2 hours printing 20 copies of one single worksheet.
Excel sent
each copy as its own print job so I had to wait for my printer to spool
20 individual print jobs. This is ridiculous. Am I missing a print
setting somewhere or do I just have to live with this problem. Any
help would be greatly appreciated.

 

[olasa]

I don't know if this is better. But you could give a try.
'www.fineprint.com' (http://www.fineprint.com)

It's a great software.

Ol

 

[Anne Troy]

Is there some reason that when you hit File-->Print, you can't type in 20 in
the number of copies?
*******************
~Anne Troy

www.OfficeArticles.com



"bloodgroove" <[email protected]>
wrote in message
news:[email protected]...

 

[bloodgroove]

I did type the number of copies needed but it still spooled each cop
as
a separate job. I don't know if others have this problem or if it'
part of
our network

 

[Dave Peterson]

Our copiers were faster than our printers.

I'd print one and copy it 19 times.

 

[Guest]

I'm having the same exact problem...It's for a user, a copier is not an
acceptable solution, unfortunately. Thanks for the idea, though! Any others?

 

[Dave Peterson]

Maybe...

Find the printer manual for that printer. Some printers have buttons you can
push that allow you to change settings. If that printer has such a setting, try
changing it to 20.

Sometimes, you can send a special printer command that changes that setting.
(Again, see the manual for the printer.)

Print to a .prn file (use the same printer as the user owns)--I don't mean a
text file that's created via File|SaveAs.

You maybe be able to build a text file with those control characters in it and
send both the Copies command and the .prn file to the printer using an old DOS
command.

copy /b copies20.txt + output.prn lpt1:

where copies20.txt is the file that holds that printer code and output.prn is
the file that you printed the data to.

 

[Guest]

We have approximately 30 users who use this printer, and it's not occurring
with only one excel file. I've changed the seconds timeout on the printer
from 120 to 250 (max allowed).
HP Color LaserJet 2600n
Excel from Office 2003 SP1

 

[Dave Peterson]

Did you try sending the control characters and the .prn file?

Did it work?

We have approximately 30 users who use this printer, and it's not occurring
with only one excel file. I've changed the seconds timeout on the printer
from 120 to 250 (max allowed).
HP Color LaserJet 2600n
Excel from Office 2003 SP1

 

[Guest]

Dave,

Thanks for your input. Are you suggesting this as a troubleshooting
measure, or as a permanent solution?

 

[Dave Peterson]

If it works nicely for you, then it could be permanent.

Dave,

Thanks for your input. Are you suggesting this as a troubleshooting
measure, or as a permanent solution?