"Paste Special - Unformatted Text" Macro

J

Jim In Minneapolis

Hi. Can somebody tell me how to create a macro to . . .

"Paste Special . . . UNFORMATTED Text"

(I've tried clicking onthe "Paste" toolbar icon during macro-creation, and
even though I DO try to record the "Unformatted Text" option, before closing
the recording . . . . when actually executing, the macro just performs a
STANDARD paste . . . i.e. NOT unformatted!)

Ugh.

Thanks for anybody's help.
 
B

Bill Foley

Try this:

Sub PasteSpecialText()
Selection.Range.PasteSpecial DataType:=wdPasteText
End Sub

Bill Foley
 
J

Jim In Minneapolis

Thanks so much, Bill.

Yes . . . that works wonderfully!

Can I ask you another question? . . .

I've just recently swithced from Word 2003 to Word 2007. I have a few
really-time-consuming macros in my Words 2003 "normal.dot". Is there any
chance I can somehow import than into Word 2007?

I don't have a clue how to go about it. What do you think?
 
G

Graham Mayor

It would help to error trap the paste macro so it doesn't fall over if there
is nothing in the clipboard

On Error GoTo Oops
Selection.PasteSpecial DataType:=wdPasteText, Placement:= _
wdInLine
End
Oops:
Beep

I assume you mean time *saving* macros? Most Word 2003 macros will run in
2007, so copy them there and see what happens. If you have a problem we may
be help you to resolve it then - see
http://www.gmayor.com/installing_macro.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top