View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Printing Excel Multiple Copies

You may find it cheaper to print one copy and then photocopy (Xerox???) the
remaining four.

Or you could try printing to a file--make sure you use the same printer driver
for the printer you're going to use.

Then you can use an old DOS command to copy that file to the printer multiple
times:

copy /b C:\a.prn+C:\a.prn+C:\a.prn+C:\a.prn+C:\a.prn lpt1:

You may want to try it on a small test (a single piece of paper worksheet???)

Stup88 wrote:

When we print multiple copies of a excel worksheet say 5, we get instead of
one seperator page we get 5. Is there a way to get excel print it as one job,
it appears it is doing 5 sepearte jobs to print the 5 copies.

Any thoughts ?

Thanks


--

Dave Peterson