Hi Jazz,
If the workbook is always the same and the Word documents are always the same, you can copy/paste the Excel cells to the Word documents, using the 'Paste Special' method with the 'paste link' option, with whatever paste format best suits your needs. From then on, any changes to the Excel data will be reflected in the documents. I don't use Visio, but I imagine it has something similar.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|