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











LinkBack URL
About LinkBacks
Register To Reply
Bookmarks