T
tiamat
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.
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.