Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Printing order

Hello again,

I have a macro (really in Word) that opens and parses information from
other documents then prints out a summary. It will print out one of 2
types of summary and then the document. The problem is that it will always
print out the first summary a few documents late, and this gets buried in
between subsequent documents/summaries. Sometimes, the other summary-
document pairs get mixed up as well, but not as often.

I refrence the documents by name to open/print/ close etc, ( which is a
pain at times) and am thinking about assigning a document object to cover
this - will this help?

Is there a way to tell the macro to wait until the document has gone to the
printer before processing futher - or could it be a problem in the network
printer queue ( and if so, what do I do).

Thanks,

Jim
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Printing order

You may want to try one of the MSWord newsgroups for a good answer.

But how about one that might be useful (or maybe not!).

Inside MSWord
tools|Options|Print tab
turn off background printing.

This means that MSWord will wait till the print job finishes before continuing.

You ever try to close MSWord when a job is still printing--you get prompted with
a warning. Turning this setting off is one way around that problem. Maybe
it'll work for you.

(If it doesn't, I'd go down the hall and ask in one of the MSWord groups.)

Jim wrote:

Hello again,

I have a macro (really in Word) that opens and parses information from
other documents then prints out a summary. It will print out one of 2
types of summary and then the document. The problem is that it will always
print out the first summary a few documents late, and this gets buried in
between subsequent documents/summaries. Sometimes, the other summary-
document pairs get mixed up as well, but not as often.

I refrence the documents by name to open/print/ close etc, ( which is a
pain at times) and am thinking about assigning a document object to cover
this - will this help?

Is there a way to tell the macro to wait until the document has gone to the
printer before processing futher - or could it be a problem in the network
printer queue ( and if so, what do I do).

Thanks,

Jim


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
printing order of worksheets pkeegs Excel Discussion (Misc queries) 0 November 29th 06 08:42 PM
Printing Columns (not A,B,C order) weezy Excel Discussion (Misc queries) 2 June 15th 06 06:56 PM
Printing in reverse order Otto Moehrbach Excel Programming 2 July 9th 05 11:26 AM
Printing in reverse order Bryan Excel Discussion (Misc queries) 3 June 22nd 05 05:30 PM
Print Macro - Printing out of order Keith Young Excel Programming 2 April 22nd 04 08:26 PM


All times are GMT +1. The time now is 06:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"