Hello,
I had a macro built to connect to a website, copy an image, then paste it into a cell on my worksheet.
This all worked great until I.T. upgraded me to Office 2007.
Now, when I try and run the following macro...
...I get an error message that prompts me to end or debug my macro:
Run-time error '1004':
Unable to get the Insert property of the Pictures class
When I click Debug, Excel has highlighted the following section of the code pasted above:
ActiveSheet.Pictures.Insert( _
"http://bigcharts.marketwatch.com/charts/............").Select
The only help remotely related to this (talking about the "Pictures.Paste" function not working in Excel 2007) that I have found on the web is at the following link:
http://support.microsoft.com/kb/931395/en-us
So am I totally out of luck with using this macro code in my new version of Excel, or is there a workaround or patch that someone knows?
Help appreciated! (I think I might have to downgrade back to Excel 2003 if this doesn't work out, what a pain)
-RLH
Bookmarks