I am familiar to how “Past link “an Excel table to Microsoft Word such that if values of excel table changes, the hyperlinked Word table follows. But what I am seeking now is that to find a way to Past link an Excel table(one is created by ctrl+t) to Word such that that if original Excel table be resized by adding or removing rows and columns, the hyperlinked Word table follows. Is there a way to do that by VBA?


I have also posted this question on Microsoft Office Forums, Microsoft Word, Word Tables

I haven't been able to make it work but this thread indicates you can edit the link to point at a named range rather than the cell references
Dynamically link Excel to Word - (paste as link wont fit need) | MrExcel Message Board

Does that method work for you?

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

@Guessed As the linked thread indicates, for a named range it dose work. But it doesn't work for a Table name. The remedy is to create a dynamic named range.

Ahh, I was only testing it with a table name. Having to use a named range is an extra complication that I didn't test directly.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia