How to make a routine that will automatically print a word file after it has been changed via an ole link to an excel file?

[Starriol]

Hello guys. I know nothing of programming and would like to know how
can I make a routine that, as I said, would print automatically a word
file after it's been changed via an ole link with an excel worksheet
(that implies I've changed the excel file).
I would like the routine to be on the excel file, so I won't need to
open the word file everytime.

Also, I made the ole link and it updates the word document after I open
it, is there a way it actualizes it without needing to open the word
document? That way the first part (the automated printing) would work.

Thanks a lot, my fellow computer lovers :) .

[Jonathan West]

1. What you are asking for is impossible. Your code in Excel will have to
open the Word document in Word in order to print it.

2. Please don't post multiple copies of the same question to different
groups. See here for reasons why.


Tips from MVPs on posting to the Word newsgroups
http://www.word.mvps.org/FindHelp/Posting.htm
--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

Post by Starriol
Hello guys. I know nothing of programming and would like to know how
can I make a routine that, as I said, would print automatically a word
file after it's been changed via an ole link with an excel worksheet
(that implies I've changed the excel file).
I would like the routine to be on the excel file, so I won't need to
open the word file everytime.
Also, I made the ole link and it updates the word document after I open
it, is there a way it actualizes it without needing to open the word
document? That way the first part (the automated printing) would work.
Thanks a lot, my fellow computer lovers :) .

[Starriol]

OK, that's not a problem for me.
I don't care if the excel files opens the word file in order to
autoprint it and actualize the word file.
As I said, I wanna change data in an excel file, that should actualize
the info on a word file ( I know how to do that part) and open the word
file to print it.

[Jonathan West]

Post by Starriol
OK, that's not a problem for me.
I don't care if the excel files opens the word file in order to
autoprint it and actualize the word file.
As I said, I wanna change data in an excel file, that should actualize
the info on a word file ( I know how to do that part) and open the word
file to print it.

This article shows how to open Word from Excel.

Control Word from Excel
http://www.word.mvps.org/FAQs/InterDev/ControlWordFromXL.htm

Having opened Word, you will need to open the document and then use the
PrintOut method to print it