Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Limiting amount of printing jobs to 1 at a time

Status
Not open for further replies.
sglab

sglab

Technical User
Jul 29, 2003
104
US
Hello everyone,

I need your help with controlling printing jobs. I'm trying to batch print a collection of Excel files. I send them to printer in a loop, using PrintOut method of Range object. I'm using ranges rather than printing entire file because not all pages of Excel file are to be printed.
I need next file, or range to start printing only when the previous has been printed. Is there a way I could do that? Simple sample code would be greatly appreciated.

Thank you in advance.
 
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
  • Question
population of italy live/real time
Replies
11
Views
397
strongm
strongm
2009luca
  • Locked
  • Question
SORT msflexgrid column 1 with decimal number 1
Replies
4
Views
329
2009luca
2009luca
2009luca
  • Locked
difficult to crteate a query very complicated 1
Replies
9
Views
1K
Andrzejek
Andrzejek
Ken01
  • Locked
  • Question
Extraction of Picture box point / pixel colors. 3
Replies
13
Views
2K
klima
K
sal21
  • Locked
  • Question
get controll type, controll name from the second panel of SStab 1
Replies
4
Views
601
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top