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.

Re: "Paste Special - Unformatted Text" Macro by Bill

Bill
Sat Nov 24 19:37:22 PST 2007

Try this:

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

Bill Foley

"Jim In Minneapolis" <JimInMinneapolis@discussions.microsoft.com> wrote in
message news:4BBDC655-7E05-4FAF-B0E0-9D745BA6795C@microsoft.com...
> 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.



Re: "Paste Special - Unformatted Text" Macro by JimInMinneapolis

JimInMinneapolis
Sun Nov 25 01:00:01 PST 2007

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?


"Bill Foley" wrote:

> Try this:
>
> Sub PasteSpecialText()
> Selection.Range.PasteSpecial DataType:=wdPasteText
> End Sub
>
> Bill Foley
>
> "Jim In Minneapolis" <JimInMinneapolis@discussions.microsoft.com> wrote in
> message news:4BBDC655-7E05-4FAF-B0E0-9D745BA6795C@microsoft.com...
> > 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.
>
>
>

Re: "Paste Special - Unformatted Text" Macro by Graham

Graham
Sun Nov 25 02:56:43 PST 2007

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Jim In Minneapolis wrote:
> 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?
>
>
> "Bill Foley" wrote:
>
>> Try this:
>>
>> Sub PasteSpecialText()
>> Selection.Range.PasteSpecial DataType:=wdPasteText
>> End Sub
>>
>> Bill Foley
>>
>> "Jim In Minneapolis" <JimInMinneapolis@discussions.microsoft.com>
>> wrote in message
>> news:4BBDC655-7E05-4FAF-B0E0-9D745BA6795C@microsoft.com...
>>> 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.