After using the 2007 ribbon menus to insert a picture on my sheet, I can
right click the picture and get an option to "change picture". But macro
recorder doesn't capture this, and I've had a hard time finding the answer in
the object model reference. What is the code equivalent of "change picture"?
Please and thanks!

On May 13, 12:59*am, B Lynn B <BLy...@discussions.microsoft.com>
wrote:
> After using the 2007 ribbon menus to insert a picture on my sheet, I can
> right click the picture and get an option to "change picture". *But macro
> recorder doesn't capture this, and I've had a hard time finding the answer in
> the object model reference. *What is the code equivalent of "change picture"?
> *Please and thanks!

You can use following:

Worksheets("Sheetname").Pictures.Insert "Filename"

Don't ask me why the pictures object not in Object model of Sheet
object.Ask MS.

Thanks Javed. Appreciate the effort to help. The code below adds a new
picture, so there are then two. I already have it solved that way - while
first deleting the one already there. I was hoping to change the image of an
existing picture.

And I agree, as I looked for a way to "speak" to the existing picture
object, I had a hard time believing it simply didn't exist in the object
model.

"Javed" wrote:

> On May 13, 12:59 am, B Lynn B <BLy...@discussions.microsoft.com>
> wrote:
> > After using the 2007 ribbon menus to insert a picture on my sheet, I can
> > right click the picture and get an option to "change picture". But macro
> > recorder doesn't capture this, and I've had a hard time finding the answer in
> > the object model reference. What is the code equivalent of "change picture"?
> > Please and thanks!
>
> You can use following:
>
> Worksheets("Sheetname").Pictures.Insert "Filename"
>
> Don't ask me why the pictures object not in Object model of Sheet
> object.Ask MS.
>
>
> .
>

> I had a hard time believing it simply didn't exist in the object
> model.

Me too!
As you say the only way appears to insert a new picture. What you could do
is start by extracting all the properties from the original Picture, in
particular it's dimensions, order-position and name. Insert the new picture
then assign all similar properties including its name (after deleting the
original picture of course).

Regards,
Peter T


"B Lynn B" <(E-Mail Removed)> wrote in message
news:1D7B4548-0B2B-4145-B7A9-(E-Mail Removed)...
> Thanks Javed. Appreciate the effort to help. The code below adds a new
> picture, so there are then two. I already have it solved that way - while
> first deleting the one already there. I was hoping to change the image of
> an
> existing picture.
>
> And I agree, as I looked for a way to "speak" to the existing picture
> object, I had a hard time believing it simply didn't exist in the object
> model.
>
> "Javed" wrote:
>
>> On May 13, 12:59 am, B Lynn B <BLy...@discussions.microsoft.com>
>> wrote:
>> > After using the 2007 ribbon menus to insert a picture on my sheet, I
>> > can
>> > right click the picture and get an option to "change picture". But
>> > macro
>> > recorder doesn't capture this, and I've had a hard time finding the
>> > answer in
>> > the object model reference. What is the code equivalent of "change
>> > picture"?
>> > Please and thanks!
>>
>> You can use following:
>>
>> Worksheets("Sheetname").Pictures.Insert "Filename"
>>
>> Don't ask me why the pictures object not in Object model of Sheet
>> object.Ask MS.
>>
>>
>> .
>>

Thanks Peter - it's helpful just to have confirmation that I should stop
looking for the answer and chalk it up to application builders' oversight. I
can live with that more easily than fretting over the possibility I've just
failed to find the right solution.

"Peter T" wrote:

> > I had a hard time believing it simply didn't exist in the object
> > model.
>
> Me too!
> As you say the only way appears to insert a new picture. What you could do
> is start by extracting all the properties from the original Picture, in
> particular it's dimensions, order-position and name. Insert the new picture
> then assign all similar properties including its name (after deleting the
> original picture of course).
>
> Regards,
> Peter T
>
>
> "B Lynn B" <(E-Mail Removed)> wrote in message
> news:1D7B4548-0B2B-4145-B7A9-(E-Mail Removed)...
> > Thanks Javed. Appreciate the effort to help. The code below adds a new
> > picture, so there are then two. I already have it solved that way - while
> > first deleting the one already there. I was hoping to change the image of
> > an
> > existing picture.
> >
> > And I agree, as I looked for a way to "speak" to the existing picture
> > object, I had a hard time believing it simply didn't exist in the object
> > model.
> >
> > "Javed" wrote:
> >
> >> On May 13, 12:59 am, B Lynn B <BLy...@discussions.microsoft.com>
> >> wrote:
> >> > After using the 2007 ribbon menus to insert a picture on my sheet, I
> >> > can
> >> > right click the picture and get an option to "change picture". But
> >> > macro
> >> > recorder doesn't capture this, and I've had a hard time finding the
> >> > answer in
> >> > the object model reference. What is the code equivalent of "change
> >> > picture"?
> >> > Please and thanks!
> >>
> >> You can use following:
> >>
> >> Worksheets("Sheetname").Pictures.Insert "Filename"
> >>
> >> Don't ask me why the pictures object not in Object model of Sheet
> >> object.Ask MS.
> >>
> >>
> >> .
> >>
>
>
> .
>