macro for PasteSpecial Unformatted

B

Beth Mc

I've tried to create a macro for paste-special -- unformatted. I used the
"record new macro" option, but this is what my macro looks like. What do I
need to put instead of "(wdPasteDefault)"?

Sub UnformattedPaste()
'
' UnformattedPaste Macro
'
Selection.PasteAndFormat (wdPasteDefault)
End Sub
 
J

Jay Freedman

Beth said:
I've tried to create a macro for paste-special -- unformatted. I used
the "record new macro" option, but this is what my macro looks like.
What do I need to put instead of "(wdPasteDefault)"?

Sub UnformattedPaste()
'
' UnformattedPaste Macro
'
Selection.PasteAndFormat (wdPasteDefault)
End Sub
Click to expand...

This is one of several situations where the recorder gets it completely
wrong. It isn't just the wdPasteDefault that's wrong, but PasteAndFormat is
the wrong method. Replace the whole line with this:

Selection.PasteSpecial DataType:=wdPasteText
 
B

Beth Mc

A

Anne Troy

K

kafkaroo

Joined
Sep 12, 2013
Messages
1
Reaction score
0
Beth Mc said:
I've tried to create a macro for paste-special -- unformatted. I used the
"record new macro" option, but this is what my macro looks like. What do I
need to put instead of "(wdPasteDefault)"?

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

--
Thanks,
Beth
Click to expand...
This is only eight years old and I just did something that worked. Instead of [Selection.PasteAndFormat (wdPasteDefault)], try [Selection.PasteAndFormat (wdFormatPlainText)].
 
Top