OK but, for the most part, the approaches discussed in this thread have all involved Excel in one way or another. Automating an Excel workbook from Word requires a lot of complexity and maintenance overheads (for an end-user) and either linking to an Excel range or embedding an Excel work still means all the maintenance work has to be done in Excel. Furthermore, if you use an Excel worksheet embedded in the Word document, using the content requires the users to actually use Excel - the document simply becomes a portal into Excel.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|