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,
pPath = range("picLocation").value
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.
.Left = range("a1").Left
.Top = range("a1").Top
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…
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Build a Retirement Calculator using Excel (learn how to use Goal Seek as a bonus)||Are you excited about this twitter chart? »|