Thread: Pictures.Insert not working in Excel 2007
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Pictures.Insert not working in Excel 2007
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
Reply With QuoteReply With Quote