Thread: How can I modify the path of existing linked picture?

Hello everybody

Is there a way to modify the path of linked pictures in an Excel sheet?

My issue is very simple: I have created a file on my PC and I have now to distribute it to other people but the links are all pointing to my own path system and other people can't see the pictures when opening the excel file (red cross)

My pictures has been inserted using the following code:

Dim AdresseImg as String
Dim p as Object
(...)
Set p = Worksheets(NomOnglet).Pictures.Insert(AdresseImg)

Also these pictures are now MsoShape objects with MsoShapeType = msoLinkedPicture

Unfortunately, I didn't find any way to obtain the path of my pictures (it was initially defined by AdresseImg)

Is there a way to load this path in a string and modify it?
I didn't find such a possibility in Shape object in Access (there is something named SourceFullName but only in Word )

I really can't understand why an elementary data like file path is not easy to access when using VBA !

Do you expect all users' systems to be the same ?
I fear you can't define a relative path to pictures that matches all users' systems.
The easiest way to accomplish this is using an internet address for each picture.

I can't know the precise user's systems as they are different customers of mine.
I think I can't use internet adress because there is thousand heavy pictures to be displayed...

Anyway, do you know the way to modify the link of an existing linked picture?