Ron, I just tested some code I have that uses
Activesheet.Pictures.Insert(filelocation).Select in Excel 2007, and it
worked fine. I did it on a new workbook. Perhaps that is the difference.
I'm using Excel 2007 SP1

Bob Flanagan

"Ron de Bruin" wrote in message
...
Hi Manfred

This is a bug in Excel 2007 that I report a long time ago
I not know a workaround

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Manfred" wrote in message
...
I want to insert pictures in an Excel-sheet by a macro.


In Excel 2003 it worked with:
ActiveSheet.Pictures.Insert( "http://www.xy.info/FotoName").Select

But in Excel 2007 i get the error: 1004 - Unable to get the Insert
property of the Pictures class.

Can somebody help me to realize this in Excel 2007?

Thanks a lot
Manfred