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 :) .
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 "Starriol" wrote in message news:1130933681.448962.206660@o13g2000cwo.googlegroups.com... > 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 :) . >
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.
"Starriol" wrote in message news:1131019270.113353.16860@z14g2000cwz.googlegroups.com... > 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 -- 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
