need a shortcut for paste special link unformatted text

noetic76 · #1 06-29-2014, 03:07 PM

Hi, I have a table in a Word template that I have linked to an Excel spreadsheet, by copying each cell in Excel and pasting into the corresponding cell in the Word template using the 'paste special, paste link, unformatted text' option from the Paste button on the ribbon.

Maybe I could have linked the two documents better in the first place, but what I am looking for now is a macro to assign to a keyboard shortcut. I've found heaps of macros that manage the paste unformatted text bit, but not the link bit. I'm a macro newbie, so I can't figure out how to modify an existing one, to retain that link.

All advice gratefully received!

Thanks, Ruth

macropod · #2 06-29-2014, 06:03 PM

Is there a reason for not setting up a single reference 'table' in Excel, then linking to that with just one link in Word? As for the macro:

Code:

Sub Demo1()
Selection.PasteExcelTable LinkedToExcel:=True, WordFormatting:=True, RTF:=True
End Sub
 
Sub Demo2()
Selection.PasteSpecial Link:=True, DataType:=wdPasteText
End Sub

The first one pastes a linked Excel table, the second one pastes linked text (as plain text).

noetic76 · #3 06-29-2014, 06:40 PM

Yeah, I had some dramas with formatting when I linked the whole table... cell-by-cell worked so I just stuck with that.

The macro works a treat, thank you very much!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Unformatted text paste macro	Ulodesk	Outlook	1	07-03-2014 02:03 PM
Paste Special: Copy and Paste Formatting Only?	tinfanide	Word	6	03-06-2013 12:21 AM
Paste Special Unformatted Text	kenwpaul	Office	2	02-25-2011 04:53 PM
Macro to paste unformatted text	Andacar	Word	2	01-05-2011 09:15 PM
Paste Special Link no longer working	MrsMoe	PowerPoint	0	12-20-2010 10:54 PM