Insert.Pictures returns suddenly a 1004 error

[Juriaan]

Dear all,

I hope you can help me with an issue I have.
I had a perfect working piece of code that fetches an online picture (value in cell) and posted this in certain file. Never had any issues.
Since December it gives me the 1004-error "Unable to get the insert property of the picture class".
In addition when I run the macro on a Mac computer it is working fine. So I can't figure out what has changed. I tried different references but nothing helps.

Does somebody had similar experience in the past? And how did you manage this?

Sub PastePic()

    If Picture_URL <> "" Then
        Set pic = ActiveSheet.Pictures.Insert(Picture_URL)
        With pic
            .ShapeRange.LockAspectRatio = msoFalse
            .Height = ActiveCell.MergeArea.Height
            .Width = ActiveCell.MergeArea.Width
            .Top = ActiveCell.MergeArea.Top
            .Left = ActiveCell.MergeArea.Left
            .Placement = xlMoveAndSize
        End With
    End If
End Sub

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Insert.Pictures returns 1004 error

I have an issue I don't seem able to solve. I have a code that always worked perfectly. Dynamically could fetch picture-url from a cell and post it in another cell. Suddenly since 6th this month it returns 1004 error "Unable to get the insert property of the picture class" Additional strange...

www.excelforum.com

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Juriaan]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Insert.Pictures returns 1004 error

I have an issue I don't seem able to solve. I have a code that always worked perfectly. Dynamically could fetch picture-url from a cell and post it in another cell. Suddenly since 6th this month it returns 1004 error "Unable to get the insert property of the picture class" Additional strange...

www.excelforum.com

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Ok thx will make sure to this!