Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I print faster?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I print faster?
Dim intCopies As Integer intCopies = Range("A1") For intTemp = 1 To intCopies ActiveWindow.SelectedSheets.PrintOut Copies:=1 Next If this post helps click Yes --------------- Jacob Skaria "vito" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I print faster?
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: Dim intCopies As Integer intCopies = Range("A1") For intTemp = 1 To intCopies ActiveWindow.SelectedSheets.PrintOut Copies:=1 Next If this post helps click Yes --------------- Jacob Skaria "vito" wrote: 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I print faster?
Is your printer capable of doing that?
vito wrote: 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: Dim intCopies As Integer intCopies = Range("A1") For intTemp = 1 To intCopies ActiveWindow.SelectedSheets.PrintOut Copies:=1 Next If this post helps click Yes --------------- Jacob Skaria "vito" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can be here some changes for a faster speed ? | Excel Worksheet Functions | |||
can this be done faster? | Excel Discussion (Misc queries) | |||
Which method is faster | Excel Discussion (Misc queries) | |||
Can faster CPU+larger/faster RAM significantly speed up recalulati | Excel Discussion (Misc queries) | |||
better/faster way than sum products? | Excel Worksheet Functions |