Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing Word doc from Excel
Ok, by searching the archives and asking for direct help, I have my
Excel macro opening, writing to, printing, and closing a Word doc. Only two things left. Given this snip of code: WdApp.ActiveDocument.PrintOut WdApp.ActiveDocument.Close savechanges:=False WdApp.Quit Set WdApp = Nothing The doc is printing, but the .Quit results in a pop-up that a print is in progress, do I really want to quit. Is there an intelligent way to check the status of the print before issuing the .Close? It's a short, one-page doc, so I could just put a delaying loop in, but I'd rather be smarter about it. Also, instead of blindly printing to the default printer, I'd like to pop up a list box to allow the user to select which printer. All assistance appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing Word doc from Excel
Looks like mvps.org will be a most useful site! I'm seeing answers to
other questions that I would have ended up asking -- I just didn't know it yet! Thanks. On Thu, 16 Oct 2003 19:07:16 -0400, Debra Dalgleish wrote: There's some information here on checking the print status: http://www.mvps.org/word/FAQs/Macros...itForPrint.htm For a list of printers: http://www.mvps.org/word/FAQs/Macros...lePrinters.htm Ed Stevens wrote: Ok, by searching the archives and asking for direct help, I have my Excel macro opening, writing to, printing, and closing a Word doc. Only two things left. Given this snip of code: WdApp.ActiveDocument.PrintOut WdApp.ActiveDocument.Close savechanges:=False WdApp.Quit Set WdApp = Nothing The doc is printing, but the .Quit results in a pop-up that a print is in progress, do I really want to quit. Is there an intelligent way to check the status of the print before issuing the .Close? It's a short, one-page doc, so I could just put a delaying loop in, but I'd rather be smarter about it. Also, instead of blindly printing to the default printer, I'd like to pop up a list box to allow the user to select which printer. All assistance appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing Word Documents from Excel | Excel Discussion (Misc queries) | |||
Printing a word doc from an excel button | Excel Discussion (Misc queries) | |||
printing word art on an excel worksheet | Excel Discussion (Misc queries) | |||
Embedding Word Docs into Excel Worksheets and Then Printing The Word Docs | Excel Worksheet Functions | |||
Printing MS Word Doc From MS Excel | Excel Discussion (Misc queries) |