need a shortcut for paste special link unformatted text

		Microsoft Office Forums > Microsoft Word > Word VBA
need a shortcut for paste special link unformatted text

FAQ

Thread Tools

Display Modes

06-29-2014, 06:03 PM

macropod

Windows 7 32bit need a shortcut for paste special link unformatted text

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,513

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).

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

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