Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-20-2021, 07:46 PM
soroush.kalantari soroush.kalantari is offline Windows 10 Office 2016
Novice
 
Join Date: Jun 2021
Posts: 6
soroush.kalantari is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 09-21-2021, 12:29 AM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 2,638
Guessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to behold
Default

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
Reply With Quote
  #3  
Old 09-21-2021, 11:16 PM
soroush.kalantari soroush.kalantari is offline Windows 10 Office 2016
Novice
 
Join Date: Jun 2021
Posts: 6
soroush.kalantari is on a distinguished road
Default

@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.
Reply With Quote
  #4  
Old 09-21-2021, 11:48 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 2,638
Guessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to behold
Default

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
Reply With Quote
Reply

Tags
hyperlinks, tables

Thread Tools
Display Modes


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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:17 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft