There are numerous unexplained issues here. For example:
What determines the opening of the Excel file? If code in the document doesn't open it, how do you guarantee the correct document is active? How do you ensure all the required content controls have the correct content? What happens if the workbook is opened and the relevant document isn't the active one (Word might not even be running)?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|