Macro To "Paste Unformatted"...

[Robert R. Champion]

I seldom paste formatted text; most of the time I have to Paste
Special-Unformatted (too bad there is not a Preference setting for that; if
there is, I can't find it!).

I've attempted to have a Word Macro do this with no success. And, I can't
seem to get one that I record with QuicKeys to work either (although I can
at least get it to the point where I can select "Unformatted text" and then
hit OK.

I'm on a Mac Mini running Office 2004 for the Mac.

Ideas/suggestions will be appreciated.

Bob C
San Francisco

PS: I just learned about this newsgroup so am taking max advantage of it!

 

[Clive Huggan]

Hello Bob,

You¹re right -- there isn¹t a preference. This is what you need:

Sub PasteSpecialPlainText()
'
' PasteSpecialPlainText Macro
' Macro recorded 22 April 2003 by Clive Huggan
'
Selection.PasteSpecial Link:=False, DataType:=wdPasteText, Placement:= _
wdInLine, DisplayAsIcon:=False
End Sub

For more information, read page 189 of some notes on the way I use Word for
the Mac, titled "Bend Word to Your Will", which are available as a free
download from the Word MVPs' website
(http://word.mvps.org/Mac/Bend/BendWordToYourWill.html).

[Note: "Bend Word to your will" is designed to be used electronically and
most subjects are self-contained dictionary-style entries. If you decide to
read more widely than the item I've referred to, it's important to read the
front end of the document -- especially pages 3 and 5 -- so you can select
some Word settings that will allow you to use the document effectively.]

You¹re welcome to take advantage of us!

Cheers,

Clive Huggan
Canberra, Australia
(My time zone is 5-11 hours different from the US and Europe, so my
follow-on responses to those regions can be delayed)
============================================================
Avoid long delays before your post appears -- use Entourage or newsreader
software -- see http://word.mvps.org/Mac/AccessNewsgroups.html
============================================================

 

[JE McGimpsey]

I seldom paste formatted text; most of the time I have to Paste
Special-Unformatted (too bad there is not a Preference setting for that; if
there is, I can't find it!).

There isn't.

I also almost never paste styled text, so I replace the Paste command by
including something like this macro (my actual macro is rather more
complicated, but highly ideosyncratic) in an add-in:

Public Sub EditPaste()
'Paste Plain Text, if possible.
On Error GoTo ErrHandler
Selection.PasteSpecial Link:=False, _
Placement:=wdInLine, _
DisplayAsIcon:=False, _
DataType:=wdPasteText
ExitSub:
Exit Sub
ErrHandler:
Selection.Paste
Resume ExitSub
End Sub

I then add an item to the menu to paste formatted text for the very rate
cases that I might want to:

Public Sub EditPasteFormatted()
Selection.Paste
End Sub

 

[Daiya Mitchell]

Addendums‹

Giving a macro the exact same name as the predefined Word command means the
macro will automatically hijack or intercept the Word command. That's what
JE did with his EditPaste macro.

Robert, I don't know how QuickKeys works, but the macro recorder in Word
2004 is broken for some things. Using Edit | Paste Special is one of them,
that's why your attempt didn't work.

Here's yet another answer to this question.
http://word.mvps.org/Mac/PasteText.html

I actually think I use "paste and match formatting" more than I paste
unformatted--the end result is not very different in my particular workflow.