Print word docs via Excel VBA

[Ducatisto]

Hello All,

I have a problem which I and others here at my place of work cannot fathom out as to why it does not work. Why would a document not print out from the print dialogue box? Here is the code that I am using which does as it says, opens the document then opens the print dialogue box but will not print, that is when I hit print nothing happens.

Please Login or Register  to view this content.

Many thanks for your help.

Colin

[Ducatisto]

The print dialogue issue is still haunting me so now I have resorted to the code below;

Please Login or Register  to view this content.

Whilst this does the job, once the print dialog box disappears the word document loses focus to the excel file, is there any code that will get the opened word document to retain focus after printing?

Many thanks.

[shg]

In the last line, you're destroying the Word instance in which the document was opened. Try deleting it.

[Ducatisto]

In the last line, you're destroying the Word instance in which the document was opened. Try deleting it.

Thanks for your reply. Strangely enough that line did not 'kill' word but as it was redundant I have deleted it. The problem is still there though, it is not a showstopper but it would be nice to have the word document holding focus instead of the excel workbook that hailed it. With the code actioned the word document opens and takes focus with the print dialog box, it is only when a user interacts with the box (selecting numbers of copies or even cancelling the request) that the word document loses focus and the user then has to regain the documents focus to carry on reading it etc. Anyone know of a work round? Many thanks.