Run-time error '1004' Unable to get the Insert property of Pictures class
hi all.
below code works fine at home but gives RTE 1004 when used in the office.
when i copy the image link in the browser's address bar, the image is displayed. and also there is no problem copying the image to a folder via some other code.
is it stg related with internet policy or do i have to reference to a library/application from tools in VBE. or stg else?
[vba]
Sub pixadd()
Dim cll As Range
Dim pth As String
Dim pix As Object
For Each cll In Worksheets("Sheet1").Range("A2:A10")
pth = "http://xxx.com/images/" & cll.Value & ".jpg"
Set pix = Worksheets("Sheet2").Pictures.Insert(pth)
Next
End Sub[/vba]