Closed Thread
Results 1 to 3 of 3

Extract and display image URL from "Linked image cannot be displayed" pictures

  1. #1
    Registered User
    Join Date
    05-10-2013
    Location
    Gold Coast, Australia
    MS-Off Ver
    Excel 2011
    Posts
    3

    Extract and display image URL from "Linked image cannot be displayed" pictures

    Hi

    I am in desperate need of help Please.
    I am using Excel for Mac 2011 and have downloaded an .xls file from my supplier's website.
    The first column is meant to contain a thumbnail of an image for each product in the list, but after downloading the file, each image shows a big red cross and states "The linked image cannot be displayed".
    I don't necessarily need the image to display but I do need to extract the URL from each image and place it in another column.

    I can do this one at a time by right clicking the image file and then selecting "Format Picture". Under "Alt Text" the URL is shown as the "Description".
    I take it that the images are not hyperlinked otherwise the URL would be displayed under "Hyperlink" too when right clicking an image?
    Due to the fact that there are literally hundreds of products on each downloaded list with multiple variations of each I cannot do this one at a time and need to be able to extract this url information ALLOT quicker.

    Is there a function in excel or a macro I can create to allow me to do this?

    I have attached a file for reference.

    xlsmarchioNuwt.xl.xls

    Thanks!
    Alan

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,572

    Re: Extract and display image URL from "Linked image cannot be displayed" pictures

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules.
    Ben Van Johnson

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Extract and display image URL from "Linked image cannot be displayed" pictures

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    http://www.excelforum.com/excel-form...-pictures.html

    Thread Closed.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

Closed Thread

Thread Information

Users Browsing this Thread

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

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