Simple macro for 'paste unformatted text' won't work

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rodmac - 16 Mar 2008 21:32 GMT

Can anyone here help me with this weirdness? Just downloaded Word2007, and
do a ton of pasting as unformatted text. I really want this as a keyboard
shortcut, which I have relied on for years.

I can't find Paste Special: Unformatted Text on the All Commands list - it
was there in Word 2000, my last version - and it isn't in the default
macros.

When I try to record a simple macro using the mouse, the resulting macro
consistently pastes the source formatting, not unformatted text. If I just
use the interface, the paste unformatted text works fine.

The macro recorder won't record the sequence, and I get this:

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

If I knew what paste unformatted was I would just edit the macro, but I
haven't a clue about VBA or whatever this language is.

Any help appreciated.

Rod

Reply to this Message

macropod - 17 Mar 2008 01:23 GMT

Hi Rod,

Try:

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

Cheers

Signature

macropod
[MVP - Microsoft Word]
-------------------------

> Can anyone here help me with this weirdness? Just downloaded Word2007, and
> do a ton of pasting as unformatted text. I really want this as a keyboard
[quoted text clipped - 24 lines]
>
> Rod

Reply to this Message

rodmac - 17 Mar 2008 05:15 GMT

Thanks a lot, macropod! Your macro did the trick and I'm back in fast
one-key text-pasting business.

R

> Hi Rod,
>
[quoted text clipped - 35 lines]
>>
>> Rod

Reply to this Message