Excel 2007 Display image from image path?

Question

I would like to insert an image into a cell. The code below inserts it into a sheet:

            With wb.Sheets(1).Pictures.Insert("\\bk01fil0001\salesdb$\ImageUpload\NoImage.gif")
            .Left = wb.Sheets(1).Range("B2").Left
            .Top = wb.Sheets(1).Range("B2").Top
            .Width = wb.Sheets(1).Range("B2").Width
            End With

Not sure what you are asking? Does code you posted not work correctly? — PaulStock
– PaulStock, Commented Sep 13, 2011 at 20:09
Try a Google search for: "insert image into a cell excel vba". Tons of info out there. — Reafidy
– Reafidy, Commented Sep 13, 2011 at 20:43

Tim Williams · Accepted Answer · 2011-09-13 21:53:02Z

1

You can't insert a picture inside a cell: they always sit "on top" of the worksheet. Best you can do is position it over the required cell/range as you are already doing.

answered Sep 13, 2011 at 21:53

Tim Williams

169k8 gold badges104 silver badges143 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ed Bolton · Accepted Answer · 2011-09-14 10:16:45Z

0

You can make things a little simpler by selecting a cell then inserting the picture...

Sheets(1).Select
Range("B2").Select
ActiveSheet.Pictures.Insert("\\bk01fil0001\salesdb$\ImageUpload\NoImage.gif")

I don't think this would ever be a less efficient method as you would only ever wish to insert a picture on a visible sheet. I do not see you would need to select the sheet more than once, if at all

(As an aside, it sounds as though you are trying to auto-insert images in one column of a table in which case I would strongly recommend using Cells notation as described in the text accompanying this Excel Visual Basic video)

answered Sep 14, 2011 at 10:16

Ed Bolton

9466 silver badges4 bronze badges

Collectives™ on Stack Overflow

Excel 2007 Display image from image path?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related