ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to update Shape pictures (https://www.excelbanter.com/excel-programming/404949-how-update-shape-pictures.html)

tiamat

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.

tiamat

How to update Shape pictures
 

bump, any ideas or this is a no go?


All times are GMT +1. The time now is 08:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com