I am trying to insert a picture from a remote website. My macro works with local files, but not remote files. Are they handled differently? I've verified the remote file is accessible with other tools, like paint.
Sub add_pic()
Dim name As String
name = "c:\users\Laura\documents\linescale\LS Pic 1.jpg"
' Both of these work
ActiveSheet.Pictures.Insert (name)
Call ActiveSheet.Shapes.AddPicture(name, False, True, 100, 100, 70, 70)
name = "http://linescale.com/spreadsheets/Forest.jpg"
' This returns message "Insert message of picture class failed"
'ActiveSheet.Pictures.Insert (name)
' This returns message "The specified file was not found"
Call ActiveSheet.Shapes.AddPicture(name, False, True, 100, 100, 70, 70)
End Sub
Bookmarks