Cush was telling us:
Cush nous racontait que :
> I got the code you sent to me to work in Excel VBA, but have two
> follow up questions:
>
> 1) How do I set a range where the picture should be pasted?
??
Well, how do you tell you code where to place the picture?
What is the intended location?
> 2) How do I anchor a picture so that it doesn't move as further
> paragraphs are written?
[quoted text clipped - 6 lines]
> the VBA code, I can't get the "Move Object with Text" to be False,
> and for the "Lock Anchor" to be True.
Locking the anchor is easy, but there is no such thing as a method or
property for "Move Object with Text". For that, you have to use the relative
position property.
Here is a Word example you can adapt to your needs:
Dim shpToPaste As Shape
Dim rgeToPaste As Range
Selection.Collapse wdCollapseStart
Set rgeToPaste = Selection.Range
rgeToPaste.PasteSpecial , False, wdFloatOverText, False, _
wdPasteMetafilePicture
Set rgeToPaste = rgeToPaste.Paragraphs(1).Range
Set shpToPaste = rgeToPaste.ShapeRange(1)
With shpToPaste
.LockAnchor = True
.RelativeHorizontalPosition = wdRelativeHorizontalPositionPage
.RelativeVerticalPosition = wdRelativeVerticalPositionPage
End With

Signature
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org