Inserted Picture is referenced instead of inserted when using VBA Picture.insert(path)

Question

I use the following code to insert a logo into an excel chart:

ActiveChart.Pictures.Insert("path\logo.jpg").Select

I see the logo and everything is fine from my point of view. But if i send this file via e-mail to a collegue which doesn't have access to the path he cannot see the picture. From this evidence i conclude that the code references the picture instead of inserting it.

How does one insert a picture permanently, such that the logo will be visible even if the path is not accessible anymore?

Is the path you are using an absolute path, meaning is it something like "C:/User/Pictures/..."? — Xabier, Dec 15 '17 at 09:08

score 2 · Accepted Answer · answered Dec 15 '17 at 09:04

2

To embed the image in the file you have to add a shape and then put the image in the shape using AddPicture

Application.ActiveSheet.Shapes.AddPicture "C:\documents\somepicture.jpg", False, True, 1, 1, 100, 100

This example comes from here

MSDN also has some information here

answered Dec 15 '17 at 09:04

Petrichor

975
1
9
22

I got a follow up question you might be able to answer too.. https://stackoverflow.com/questions/47829743/inserting-shape-causes-inconsistent-in-vba-excel – Lucas Raphael Pianegonda Dec 15 '17 at 09:54

Inserted Picture is referenced instead of inserted when using VBA Picture.insert(path)

1 Answers1

Linked