I have a workbook that prints out a statement multiple times. This statement is just a template located on 1 tab.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
VBA runs a loop that scrolls through a list of data which flows to the statements, changes the statement, then prints the statement, and then starts over with the new data and prints out the statement over and over depending on the range of data all on 1 tab. <o></o>
<o></o>
So, as of right now, each time the loop prints out the statement, I get a separate print document sent to the printer for each loop. This works great until i have 3 or 4 people working on different workbooks that try to print at the same time. The statements are printed out at random and then must be separated (which could be hundreds of statements).<o></o>
<o></o>
An answer to my problem is to be able to save the print out in an array or VBA and then send all the print outs to the printer at once as 1 document. That way, if 2 people printed out a workbook at the same time, the printer would print out 1 complete job and then print out the next...saving separating or random print out intertwined in specific sets of print outs.<o></o>
<o></o>
Printing to .pdf is too slow and reduces the quality of the print image. I already tried that.<o></o>
<o></o>
So, can I some how print out a tab, change it, and then print it out...but to only 1 print spool, all through in VBA?<o></o>
<o></o>
Thanks for the help!!!!!!!!!<o></o>
<o> </o>
<o></o>
VBA runs a loop that scrolls through a list of data which flows to the statements, changes the statement, then prints the statement, and then starts over with the new data and prints out the statement over and over depending on the range of data all on 1 tab. <o></o>
<o></o>
So, as of right now, each time the loop prints out the statement, I get a separate print document sent to the printer for each loop. This works great until i have 3 or 4 people working on different workbooks that try to print at the same time. The statements are printed out at random and then must be separated (which could be hundreds of statements).<o></o>
<o></o>
An answer to my problem is to be able to save the print out in an array or VBA and then send all the print outs to the printer at once as 1 document. That way, if 2 people printed out a workbook at the same time, the printer would print out 1 complete job and then print out the next...saving separating or random print out intertwined in specific sets of print outs.<o></o>
<o></o>
Printing to .pdf is too slow and reduces the quality of the print image. I already tried that.<o></o>
<o></o>
So, can I some how print out a tab, change it, and then print it out...but to only 1 print spool, all through in VBA?<o></o>
<o></o>
Thanks for the help!!!!!!!!!<o></o>
<o> </o>