I would like to embed and image into an excel spreadsheet using .vbs

[jloyzaga]

I would like to embed an image into an excel spreadsheet via code. the image is "C:/image.png" and I want to embed it into sheet1:cell:a1:a1
I can put a hyperlink by using this code

oEngine.ActiveSheet.Hyperlinks.Add objSheet.Cells(Row, 6), "", screenshotname, screenshotname


But I'd like to actually have the image in the cell- can anybody help?
Thanks
Joe

 

[SkipVought]

hi,

But I'd like to actually have the image in the cell

The Shapes collection, is part of the Sheet object, not the Range object, which is where a Cell is.

Use your macro recorder to add a shape (image) to the sheet and then position/size the shape to appear to be in the desired cell, using the cells, top, left, width, height properties.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}