| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pictures.Insert not working in Excel 2007
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pictures.Insert not working in Excel 2007
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pictures.Insert not working in Excel 2007
Test a picture on the Web Bob
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Bob Flanagan" wrote in message . .. 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pictures.Insert not working in Excel 2007
Btw:
This is only a bug with a picture on the Web -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ActiveSheet.Pictures.Insert problem in excel 2007 | Excel Programming | |||
| Pictures.Insert not working correctly in excel 2008. | Excel Programming | |||
| How do I insert pictures in excel with the correct aspect ratio? | Excel Discussion (Misc queries) | |||
| Insert & link a graphic file in Excel 2003 -- updatable pictures! | Excel Discussion (Misc queries) | |||
| batch insert pictures one time in excel macro | Excel Programming | |||
![Manfred[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
