Ask a new question

Word VBA PasteAndFormat vs. PasteSpecial

Is there a functional difference between the following: 

Via Home > Paste > Paste Special > Keep Text Only:

Selection.PasteAndFormat (wdFormatPlainText)

Via Home > Paste > Paste Special > Unformatted Text: 

Selection.PasteSpecial Link:=False, DataType:=wdPasteText, Placement:= _

        wdInLine, DisplayAsIcon:=False

For the specific case of text only / unformatted text, there is no difference that I can see. Possibly some very complicated table constructions would come out differently, but I doubt it.

Of course, the PasteSpecial method is intended for all types of objects that can be on the clipboard and for more complex manipulations, while PasteAndFormat is specialized for tables and doesn't support linking or floating objects.

_____________________________
https://jay-freedman.info

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated October 5, 2021 Views 982 Applies to: