+ Reply to Thread
Results 1 to 2 of 2

Display pictures from URL links in MS Excel for Mac 2011

  1. #1
    Registered User
    Join Date
    09-19-2017
    Location
    UK
    MS-Off Ver
    Office for Mac 2011
    Posts
    1

    Display pictures from URL links in MS Excel for Mac 2011

    Hey there.

    I am new here (and new to macros!), but have a pretty good Excel knowledge. I am hoping someone can help me decipher this little challenge to display some nice thumbnail images in my worksheet!! Its been killing me!

    I am trying to find a macro that I can use in VBA to take a column of URL links (B2:B103) and display the images in the next column at cells C2:C203. The URLs are all direct links to photos that are uniformly sized.

    Example here: https://secure-i2.ztat.net//detail/C...default__2.jpg

    I have found the below code, which I have inserted in a new Module using VBA and Run as a Macro - but this is not doing what I need in Excel for Mac 2011. It does all the column, row formatting etc perfectly, but it does not do the most important thing - i.e. display the image!! :-(

    Sub IMAGE()
    Dim Rng As Range
    Dim Cell As Range
    Dim Pic As Picture
    Application.ScreenUpdating = False
    Columns("J:J").ColumnWidth = 21.29
    Set Rng = Range("K2:K" & Range("k" & Rows.Count).End(xlUp).Row)
    For Each Cell In Rng
    With Cell
    On Error Resume Next
    Set Pic = .Parent.Pictures.Insert(.Value)
    If Err <> 0 Then
    Err.Clear
    Else
    With .Offset(, -1)
    Pic.Top = .Top
    Pic.Left = .Left
    Pic.Height = .Height
    Pic.Width = .Width
    End With
    End If
    On Error GoTo 0
    End With
    Next Cell
    Rng.EntireRow.RowHeight = 120
    Application.ScreenUpdating = True
    End Sub


    It seems a common issue. I wonder if there is some kind of missing functionality in Excel for Mac 2011? In fact, I have found no method whatsoever in Excel for Mac 2011 to insert an image directly from a URL location. Even the [Insert > Photo > Picture from file... > Choose a picture] dialogue box does not seem to accommodate a pasted file location, one can only click and select a local file from the file menu.

    Can anyone please help me with this?

    Thanks so much. :-)

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Display pictures from URL links in MS Excel for Mac 2011

    Hi,

    The only method I have seen anywhere to do this is using a comment like this
    Please Login or Register  to view this content.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ 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. 2011 Excel for Mac: Numbers will not display in cell
    By paulgarett in forum Excel General
    Replies: 1
    Last Post: 09-25-2013, 06:19 PM
  2. display in status bar sum of cells highlighted by cursor Excel 2011
    By k eith in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 09-19-2013, 09:45 PM
  3. Excel 2011 Chart display is backwards
    By TimeMachine in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-22-2013, 05:23 PM
  4. 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
  5. 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
  6. Replies: 0
    Last Post: 11-04-2008, 06:53 AM
  7. Search an Excel Database and display results w/ pictures.
    By Schmoozer in forum Excel Programming / VBA / Macros
    Replies: 41
    Last Post: 06-27-2007, 12:28 AM
  8. 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

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