[Herb Tyson [MVP]]

I'm glad it worked. It took a bit of detective work to figure out, since the
macro recorder recorded paste special as PasteAndFormat, instead.

--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com


"WSR" wrote in message
...
Thanks Herb & PamC

Using the following VB allows me to Paste/Special/Picture (Enhanced
Metafile)


Sub PasteSpecialPicture()
'
' PasteSpecialPicture Macro
'
'
Selection.PasteSpecial DataType:=9
End Sub


"Herb Tyson [MVP]" wrote in message
...
Try this line:

Selection.PasteSpecial DataType:=9

--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com


"WSR" wrote in message
...
What I want to do is cut from another application and paste special as a
picture (enhanced metafile) format.

When I record the macro as you describe, the cut some cells from an
Excel file the result in the Word file is a table, not a picture.

Any ideas with my macro?

Here's the VB

Sub PasteSpecialPicture()
'
' PasteSpecialPicture Macro
'
'
Selection.PasteSpecial (wdPasteEnhancedMetafile)
End Sub


Thanks 8^


"PamC via OfficeKB.com" u43222@uwe wrote in message
news:88eb70a316bcc@uwe...
First copy an image. Then turn on the macro recorder, and go to it.
You need
to record the steps for pasting an image that is already in memory (the
clipboard).

PamC

WSR wrote:
My question regarding the macro is how do I make it "generic" so that
it's
pasting what ever object I cut?

When I try to record the macro from a blank sheet, the paste button is
greyed out.

What I don't what the macro to do is Paste Special / Picture the same
object
over and over again.

I want it to Paste Special the last object on the clipboard.

If this makes any sense.

Have you tested that method?

[quoted text clipped - 7 lines]

Any guidance/assistance is appreciated

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...neral/200808/1