can only print one page at a time? help!

C

claire

when i work in works, i can set a page to print say 50 copies, and it will
print one after the other counting how mnay copies left to print. When i
print in excel, it will print each page individually, rather than a 'job lot'
so to speak! it is really frustrating as i cannot work on pc, as it opens a
new window with printer status for each and every page! whereas with works,
i can stick it in background and it carries on with no bother!
Any ideas?
 
B

Bill Kuunders

No idea at all..........
But I thought I'll reply cause no one else has.
You should be able to do exactly the same as in works.
Print how ever many copies you like.
You have tried it in the normal <file><print....>command
On the righthand side it shows a selection for number of copies.
Did you get a new printer driver?
Have a look at something like spool settings.
Regards
Bill K
 
D

Dave Peterson

This might not work...

Some printers have hardware controls (buttons on the printer) that allow you to
change settings.

Maybe you can change the setting to print 50 copies of the next print job that
goes through.

And depending on what kind of printer you're using, you may be able to prepend
that escape sequence to your print job.

Create a text file on your pc that contains those escape characters:
You'll have to find the user manual for the printer

For HP printers, it's:
ESC, ampersand, lowercase-ell, (# of copies here), uppercase X

In hex:
27, 26, 6C, 35, 30, 58
<-, &, l, 5, 0, X (what you may see in your editor)

If you're not using an HP printer (or not emulating an HP printer, get the
manual out.)

(Get one of the Geeks at work to create this text file for you.)

I saved mine as: c:\copy50.txt

Then print your workbook to a file on the pc (there's an option on the
file|print dialog)

When that's done, you go Shell to DOS and issue a print command.

copy /b c:\copy50.txt + c:\myprintjob.prn lpt1:


And if it works (test with a smaller number than 50!), have that geek create a
..bat file that does that print command. Ask him (they're never hers!) to put a
short cut on your desktop--so all you have to remember is to print to the same
file name and then run that short cut.
 
Top