Microsoft Excel Triggers Microsoft Word

[doodles82a]

Good morning. Here's what I'd like to accomplish. I have forty
templates stored in word in the same file path. Each template is
static, except for one line which will be tied to information that a
user types into an excel workbook. The user will also use excel to
select which word templates they wish to print. A Table of Contents
will be created in word that identifies specifically which word
templates were selected in excel. All selected word templates, as well
as the automated Table of Contents, should print as one print batch.

I know nothing about the interaction between Excel and Word, so I'd
like to self-study the subject, particularly as it pertains to this
objective. But, I'd like to avoid a meandering approach to my
research. Can anyone recommend any reading material that specifically
addresses this objective? In absence of any specific reference
material, can anyone recommend material that addresses the interaction
between excel and word in general?

Thank you so much for your time and consideration.

Michael

 

[ryguy7272]

You may find what you need here:

http://word.mvps.org/faqs/interdev/ControlXLFromWord.htm

http://word.mvps.org/faqs/interdev/controlwordfromxl.htm


Hope that helps,
Ryan---