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...
Please Login or Register  to view this content.
...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