Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / November 2005

Tip: Looking for answers? Try searching our database.

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?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Starriol - 02 Nov 2005 13:14 GMT
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 - 02 Nov 2005 13:22 GMT
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

Signature

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

> 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
[quoted text clipped - 8 lines]
>
> Thanks a lot, my fellow computer lovers :) .
Starriol - 03 Nov 2005 13:01 GMT
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 - 03 Nov 2005 14:13 GMT
> 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

Signature

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 


Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.