need a shortcut for paste special link unformatted text

macropod · #1 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 · #2 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