Excel 2007 Prohibits Shapes.AddPicture from URL?

[Lazzaroni]

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.

 

[Lazzaroni]

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 doesn’t record any of the insert actions in the macro, so I can’t
see what method Excel 2007 is using to insert the image.

 

[Ron de Bruin]

Hi Lazzaroni

I report this bug a few months ago

 

[Lazzaroni]

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

 

[Lazzaroni]

And this regarding macro recording:

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