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 !![]()
Bookmarks