+ Reply to Thread
Results 1 to 5 of 5

pictures and links

Hybrid View

  1. #1
    Registered User
    Join Date
    02-07-2025
    Location
    Moscow
    MS-Off Ver
    365
    Posts
    6

    pictures and links

    Hello
    Can't find the way to share pictures via my shared excel through the links.
    By clicking on link the pictures can be opened only on PC that actually sharing the photos.

    Perhaps the link is incorrect?
    =IFERROR(HYPERLINK(CONCAT("C:\Users\WH\OneDrive\Desktop\DB\Pics",D2139,".jpg"),"PIC"),"")
    Please advise, thanks

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,415

    Re: pictures and links

    I think you'd need to put the pictures on a shared network drive and hyperlink to that.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    02-07-2025
    Location
    Moscow
    MS-Off Ver
    365
    Posts
    6

    Re: pictures and links

    One driver is the shared one. I dont know how to make external link ?
    Last edited by LeoExcel; 02-10-2025 at 07:22 PM.

  4. #4
    Registered User
    Join Date
    02-07-2025
    Location
    Moscow
    MS-Off Ver
    365
    Posts
    6

    Re: pictures and links

    Because if I share via One drive links directly, I got some sort of dynamic link without any sequence, like:
    1drv.ms/i/c/h21b19fa7e7db2b7/EbeyfX22GRsggLiEAgVVAAAB1grenylT4TRJsBbde6uVoA?e=2XRd6B

  5. #5
    Registered User
    Join Date
    02-07-2025
    Location
    Moscow
    MS-Off Ver
    365
    Posts
    6

    Re: pictures and links

    Someone else (who is not on the same network) can't open a link to my "C" drive.
    OneDrive generates these dynamic links, as I just sent. Manual entry of this link can take forever. That's why I'm looking for a simpler way, since all the photos are on OneDrive.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Display pictures from URL links in MS Excel for Mac 2011
    By perranben in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2017, 03:17 AM
  2. convert picture links to actual, embedded pictures?
    By Adinmem in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-13-2013, 04:41 PM
  3. How to Extract links from pictures in Word.
    By fadu4u in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-15-2012, 11:24 PM
  4. Detection of charts, pictures and external links
    By bostjank in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-14-2006, 06:51 AM
  5. [SOLVED] Pictures.Visible question (after adding many pictures, they stop disappearing)
    By Abe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2006, 01:35 PM
  6. [SOLVED] Excel's Compress Pictures or deleting pictures doesn't seem work
    By guidod in forum Excel General
    Replies: 1
    Last Post: 01-29-2006, 02:50 AM
  7. Linking Pictures located externally, to change links based on vloo
    By RaiCin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-19-2005, 02:05 PM

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