Dave,

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

"Dave Peterson" wrote:

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

Did it work?

kshelton wrote:

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" wrote:

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.




kshelton wrote:

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?

"bloodgroove" wrote:




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.


--
bloodgroove
------------------------------------------------------------------------
bloodgroove's Profile: http://www.excelforum.com/member.php...o&userid=18281
View this thread: http://www.excelforum.com/showthread...hreadid=390610



--

Dave Peterson


--

Dave Peterson