LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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.

 
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 Word Documents from Excel Richard Excel Discussion (Misc queries) 0 June 13th 08 04:20 PM
Printing a word doc from an excel button Alec H Excel Discussion (Misc queries) 0 February 13th 06 02:23 PM
printing word art on an excel worksheet dino Excel Discussion (Misc queries) 1 November 8th 05 04:28 PM
Embedding Word Docs into Excel Worksheets and Then Printing The Word Docs mr_melvis Excel Worksheet Functions 1 April 8th 05 03:00 AM
Printing MS Word Doc From MS Excel Anthony Excel Discussion (Misc queries) 2 March 16th 05 08:37 AM


All times are GMT +1. The time now is 01:20 AM.

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

About Us

"It's about Microsoft Excel"