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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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