+ Reply to 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,570

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

    Edit:

    Mods have closed the other TWO, you may continue on this 1
    Last edited by FDibbins; 05-12-2013 at 09:53 PM.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    07-17-2013
    Location
    leeds
    MS-Off Ver
    Excel 2010
    Posts
    1

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

    Hi Alan,

    I realise that this reply is probably too late to be of any help to you, but in case other people run into this problem:

    Your .xls file was created dynamically using a web service. You can open it in any text editor, and it will display as HTML

    You can then just use Regex or some macro to gather all the <img> tags, and get the URLs from there:
    <img src="http://www.otticanet.it/img/imgocchiali/37/ico_art_Boll__OURAY_11541.jpg" border="0" width="140" align="middle"/>


    Alternatively, you could just open the spreadsheet in a browser (change the extension to .html and open it) to be able to see the images

    Regards,
    Luke

+ Reply to 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