I was using Shapes.AddPicture in Excel 2003 to add pictures using a ULR
address for an online image as the Filename. It worked perfectly, even with
LinkToFile = True.

It appears, however, that Excel 2007 no longer allows the use of a URL as
the Filename for Shapes.AddPicture.

Can anyone confirm this? Is there some security setting in Excel 2007 that I
have to change?

Thanks.

More wierdness€¦

I confirmed that it is possible to use a URL for an online image when
inserting an image manually in Excel 2007 (Insert Tab Picture Link to
File), so I tried to record the action as a macro. For some reason, however,
Excel 2007 doesnt record any of the insert actions in the macro, so I cant
see what method Excel 2007 is using to insert the image.

Hi Lazzaroni

I report this bug a few months ago

--

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


"Lazzaroni" wrote in message ...
More wierdness€¦

I confirmed that it is possible to use a URL for an online image when
inserting an image manually in Excel 2007 (Insert Tab Picture Link to
File), so I tried to record the action as a macro. For some reason, however,
Excel 2007 doesnt record any of the insert actions in the macro, so I cant
see what method Excel 2007 is using to insert the image.

http://support.microsoft.com/kb/928983/en-us

And this regarding macro recording:

http://support.microsoft.com/kb/937620/en-us