Macro Paste Special

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JW - 23 Aug 2005 16:00 GMT

I would like to create a macro that will do a Special Paste (from the
clipboard) as unformatted text.

The paste is coming from an Excel file and everytime I run the macro it
pastes it as a table and I want it unformatted.

Help !! ... Thanks a bunch
JW :o)

Reply to this Message

Greg - 23 Aug 2005 16:26 GMT

Sub PasteSpec()
Selection.PasteSpecial DataType:=wdPasteText
End Sub

Reply to this Message

Edward Thrashcort - 23 Aug 2005 17:35 GMT

WHS and I would store it in the Normal template and assign it the keyboard
shortcut Ctrl-Shift-Ins

Eddie

Reply to this Message

EFList - 24 Aug 2005 05:16 GMT

Here is what I created:

Sub PasteSimple()
'
' PasteSimple Macro
' Macro recorded 6/23/2005 by pnajoan
'
Selection.PasteSpecial Link:=False, DataType:=wdPasteText
End Sub

Enjoy!

> I would like to create a macro that will do a Special Paste (from the
> clipboard) as unformatted text.
[quoted text clipped - 4 lines]
> Help !! ... Thanks a bunch
> JW :o)

Reply to this Message

Rate this thread: