A few questions:
1. Why an embedded Word document, rather than a Word template stored in the same folder as the workbook?
2. Does the Excel table always span the same range?
3. Why does your last code block loop through all tables in the document instead of processing just the one that's being inserted/updated?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|