Pictures.Insert not working in Excel 2007

[Manfred]

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

 

[Ron de Bruin]

Hi Manfred

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

 

[Bob Flanagan]

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]

Test a picture on the Web Bob

 

[Ron de Bruin]

Btw:

This is only a bug with a picture on the Web