Time to showoff your VBA skills – Help me fix ActiveSheet.Pictures.Insert snafu

Okay, I am trying to build something hush hush super cool using excel but hit a roadblock trying to load images from a URL to my excel sheet.

What is the problem?

I am trying to insert an image from a URL to my excel 2007 workbook using VBA. The code I have used is,

Dim pPath
pPath = range("picLocation").value
ActiveSheet.Pictures.Insert(pPath)

When I try to run it, the error is “Unable to get the Insert property of the Pictures class”
Now, after googling I bumped on this piece of code recommended to fellow VBA coders who had the similar problem.

With ActiveSheet.Pictures.Insert(pPath)
.Left = range("a1").Left
.Top = range("a1").Top
End With

Well, I tried that, but still the same error. After spending what seemed like a couple of hours I am turning to you.

Do you know how to insert images (from URLs) to excel workbook using VBA?

Paste your code in comments. Lots of love and admiration is awaiting…