Macro to paste unformatted text

macropod · #2 01-05-2011, 01:40 PM

Hi Andacar,

Without seeing your code, it's hard to say what you might be doing wrong. However, there is a simpler way: simply go to Word Options > Advanced > Cut, Copy & Paste and set the 'Pasting from other programs' parameter to 'Match destination formatting'.

For a macro solution, try:

Code:

Sub PasteUnformattedText()
' The next line is in case there's nothing in the Clipboard
On Error Resume Next
Selection.PasteSpecial DataType:=wdPasteText
End Sub

You might want to add this to a keyboard shortcut.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to create macro to paste text after style?	Srivas	Word	0	03-16-2010 05:28 AM
Selected text and logo in one macro	marijke	Word VBA	0	08-24-2009 07:01 AM
Textbox & Edit Paste text	MikeWM	Word VBA	1	08-20-2009 06:21 PM
Strip lf/cr from text	p3aul	Word	9	08-18-2009 12:42 AM
paste formated text from Word to only one Excel cell	heron	Word	1	12-06-2005 02:37 AM