|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can a Macro be run such that by which an Excel table (one is created by ctrl+t) be “Pasted Link” to
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 |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
@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.
|
#4
|
||||
|
||||
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 |
Tags |
hyperlinks, tables |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can an Excel table (one is created by ctrl+t) be “Pasted Link” to Microsoft Word such that if origin | soroush.kalantari | Word Tables | 0 | 09-04-2021 08:16 PM |
Web string/link in Excel, Mail merged into Word and then pasted into Messages on Mac issue | Alex Knight | Excel | 0 | 12-08-2016 08:33 AM |
a table pasted in word from excel is not similar to the original table in excel | Mukapa | Word Tables | 1 | 01-18-2016 07:31 AM |
Modify a just-pasted Excel table | p45cal | Word VBA | 2 | 09-26-2015 01:02 PM |
connectors between cells in pasted Excel table | eNGiNe | Word | 7 | 10-16-2013 11:58 PM |