- Jul 26, 2006
- 143
- 2
- 81
I have a macro that collects data, create a form, then sends that page to be printed.
The problem: Data collection takes almost 1 minute. So if I need to run this 100 times it means 1 page is printed every minute.
Is there a simple/easy way I can have excel create an internal 'print' queue, so after it runs 100 times, it just sends 100 print jobs to the printer (so they print all at once)?
I am thinking I can probably re-code the macro so it creates a new worksheet for each time it runs, then after 100 items are created it just loops over all of them... But I am hoping for maybe something a bit cleaner?
The problem: Data collection takes almost 1 minute. So if I need to run this 100 times it means 1 page is printed every minute.
Is there a simple/easy way I can have excel create an internal 'print' queue, so after it runs 100 times, it just sends 100 print jobs to the printer (so they print all at once)?
I am thinking I can probably re-code the macro so it creates a new worksheet for each time it runs, then after 100 items are created it just loops over all of them... But I am hoping for maybe something a bit cleaner?