Help with "Paste Special" in a macro

C

Charlie

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/
 
C

Charlie

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

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/


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

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