I have an Excel sheet (assume sheet 5) with several images in it. That is to say .jpg or .png. I do this:
sheethandle = get(Sheets, 'Item', 5);
Activesheet = Excel.Activesheet;
Shapes = sheethandle.Shapes;
for s = Shapes.Count:-1:1
At this point, the Shapes variable shows a count of 0 when examined in the workspace. However, the Excel sheet still shows all the images intact. What do I need to do to make it work?