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…
