Help with "Paste Special" in a macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Charlie - 01 Mar 2005 19:40 GMT

I'm trying to get a small macro to work.... what I need is to get a
macro that will duplicate the Word command sequence of

Edit
Paste Special
then in the "As:" box select Unformatted Text.

I've tried the macro recorder, but it always records the "default"
selection, not Unformatted Text.

ie: Selection.PasteAndFormat (wdPasteDefault)

Whar should I be doing?
Charlie Hoffpauir
http://freepages.genealogy.rootsweb.com/~charlieh/

Reply to this Message

Charlie - 01 Mar 2005 19:57 GMT

Oops, posted too soon, I found it in a section of the Help file that
I'd overlooked:

Selection.Collapse Direction:=wdCollapseStart
Selection.Range.PasteSpecial DataType:=wdPasteText

does what I need.

>I'm trying to get a small macro to work.... what I need is to get a
>macro that will duplicate the Word command sequence of
[quoted text clipped - 11 lines]
>Charlie Hoffpauir
>http://freepages.genealogy.rootsweb.com/~charlieh/

Charlie Hoffpauir
http://freepages.genealogy.rootsweb.com/~charlieh/

Reply to this Message