Hi Kim
The problem is how big do you want the table to be in Word!!!!
What you could do is create an Auto Macro which runs as soon as you open MS Word which will copy the current table as it stands.
Would this give you what you want?


Tony(OTPM)

Hi Kim

I have just fouynd a similar post on another Forum from Paul Edstein an MS Word MVP who provides a possible solution. Try his link:@

http://www.mrexcel.com/forum/showthread.php?t=335522

Come back to the forum if you are still struggling.

Tony(OTPM)

Thanks Tony,

Wow! The dynamic link sounds possible and legit after all . The table in Word is just about five to eight columns maximum, though the rows may vary depending on the data population.

To give you an idea, here's why I need this dynamic link to work. There is already a standard company-wide pre-formatted report in Word, complete with Tables, spaces for Images and the usual narrative report. The requirement is just to populate the tables based on the Excel data which changes every quarter. There is about 40 tables at hand to be updated regularly.

Thus, if a DYNAMIC link from Excel to Word is truly possible then your idea that as I open the Word so will the data auto-refresh itself is brilliant next to none.

To answer your last note, indeed, it will give me more than I can bargain for.

Best regards,

Kim

Hi Kim
If your standard word document is not confidential can you let me have a copy and I will see how it can be set up to pick up Excel tables Automatically (you can send it to otpm@blueyonder.co.uk if that is acceptable or failing that just give me a sample Word Document of the format to work from.
Tony(OTPM).

Hi Kim,
In that case, provided you set up the LINK field as described in the link Tony posted, all you will need to do for changes to the # or rows is to change the range in Excel to which the named range referred to in the LINK field applies.

You also mention the need for this to be used in:
Do note that the paths in Word's LINK fields are absolute. If you move the Excel file, you'll need to change the link path in Word (eg via Edit|Links). Likewise if you provide the 'automated' report to others for their use - they'll need to change the links to point to their own Excel workbooks (and the named ranges within).

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Tony,

Thanks again for the reply. I will email the data as adviced for your further evaluation. On second thoughts, and taking hint from Paul's note, if my desired output appears ideal yet complicated then I am open to a more practical approach, other than making the dynamic link option, to yet accomplish the auto-updating of the pre-formatted report in Word.

Let's give it time. I will consolidate files from my end and email you in time. Not really that urgent to make it soon. What I am getting now, of which I am confident of your assessment is that it is indeed possible, and so I will now consider this query solved ... and my pre-forum verdict as mere speculative at best.

...just can't wait. Ha ha ha. I just sent you today the pre-formatted .doc report for your evaluation. You are free to email Paul it that suits well too.

Cheers then and thanks. Will keep in touch.

Kim