How do I print faster?

V

vito

Hi! I made a VBA macro which print out copies of diffrent pages. The number
of copies is decided in a cell. The code is activeworksheets.printout
copies:=value
This works but the printer prints out the pages one by one instead of in one
flow.
Is there anyone knowing how I can make the printer print the pages in one
flow?
 
J

Jacob Skaria

Dim intCopies As Integer
intCopies = Range("A1")
For intTemp = 1 To intCopies
ActiveWindow.SelectedSheets.PrintOut Copies:=1
Next

If this post helps click Yes
 
V

vito

Thank you for answer but I think that the loop will make one copy at the time.
What I want is to send one file to the printer so that the printer prints
all copies at the same time.
Now it prints one copy than it wait a moment then comes the next copy and so
on.

"Jacob Skaria" skrev:
 
B

Bob I

Is your printer capable of doing that?
Thank you for answer but I think that the loop will make one copy at the time.
What I want is to send one file to the printer so that the printer prints
all copies at the same time.
Now it prints one copy than it wait a moment then comes the next copy and so
on.

"Jacob Skaria" skrev:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top