View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tiamat tiamat is offline
external usenet poster
 
Posts: 6
Default How to update Shape pictures

I am using Office 2007 and am currently displaying images in a worksheet via :

wksheet.Shapes.AddPicture (tmpFile
,
Microsoft.Office.Core.MsoTriState.msoFalse
,
Microsoft.Office.Core.MsoTriState.msoTrue
, sheetLocationX, sheetLocationY
, width, height);

Where tmpFile is a temporary image file holding the image. I do not wish to
link to this file and have chosen for the data to be saved with the worksheet.

My question is :

Is there a way that I can update the picture data for the Shape?

In context :

1. The worksheet could be sent to another machine which could modify the
picture.

2. On the same machine, the excel shape image is often linked into a
powerpoint presentation. I wish to be able to update the Excel.Shape object
with a new image and have that change reflected in the linked PowerPoint
document.