2007 Word Macro to Paste Special Unformatted Text

[judgehopkins]

Sub PasteSpecialUnformatted()
'
' PasteSpecialUnformatted Macro
'
'
    Selection.Collapse Direction:=wdCollapseStart
    Selection.PasteSpecial DataType:=wdPasteText
End Sub

Sub test()
'
' test Macro
'
'
    Selection.PasteAndFormat (wdPasteDefault)
End Sub

I got the first macro from Word's help files.

When I select text to replace and run the macro, it correctly inserts the contents of the clipboard but does not replace the selected text.

I got the second macro by recording the keystrokes for paste special/unformatted text.

When I select text to replace and run the macro, it correctly inserts the contents of the clipboard and does replace the selected text, but it is not unformatted text.


What am I doing wrong?

Thanks!

There are two guaranteed rules of success: First, never tell everything you know.

 

[SkipVought]

Hi,

Please post VBA code question in Forum707

Skip,

_{Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference!}

 

[judgehopkins]

Will do...thanks, Skip!

There are two guaranteed rules of success: First, never tell everything you know.