Sorry about the previous post! I guess my mouse got a mind
of it's own. I am doing the following in a loop
Open Workbook
Activate proper worksheet
Set Print Area
Print worksheet
Close Workbook
This will be done on approx 150 to 200 workbooks. My
question: does the PrintOut method 1)simply queue the print
job, in which case I'm wondering: could I run out of memory
during the process and if so, are there workarounds or
2)does it wait for the print job to complete (I don't see
any flag parameter such as Wait/No Wait to request that it
wait to continue coding). I would assume it does the former
but am not sure about whether this could be troublesome. I
don't easily have access to the data it'll be used with so
it's hard to do a test run. I am not sure how much memory a
print queue can allocate or if it caches disk space, etc.
All the innards of printing are foreign to me. Thanks in
advance! Sincerely, Phil