+ Reply to Thread
Results 1 to 4 of 4

How can I modify the path of existing linked picture?

  1. #1
    Registered User
    Join Date
    06-16-2011
    Location
    Paris, France
    MS-Off Ver
    Excel 2010
    Posts
    3

    Exclamation 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 !
    Last edited by Logique; 06-18-2011 at 12:54 PM. Reason: Not enough responses

  2. #2
    Registered User
    Join Date
    06-16-2011
    Location
    Paris, France
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Need to modify linked picture path

    Oups Sorry:

    I didn't find such a possibility in Shape object in Access :

    It's not Access but Excel, of course !

  3. #3
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Need to modify linked picture path

    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.



  4. #4
    Registered User
    Join Date
    06-16-2011
    Location
    Paris, France
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Need to modify linked picture path

    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?
    Last edited by Logique; 06-18-2011 at 12:55 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1