I have heard 2007 won't record macros for drawing objects, it must apply to
pictures also. Anyway, my version does record and the code is exactly what
you tried to use and got the error. Of course 2000 & 2003 gives me a picture
of a black dog lying in the yard.
I would assume this is some security issue that 2007 has addressed
concerning web-based pictures being freely written to Excel. It may be as
simple as allowing some security option in Excel.
Good Luck,
Mike F
"Dave" wrote in message
...
On Mar 21, 3:46 am, "Mike Fogleman" wrote:
I don't have 2007, but have you tried to record a macro while you do the
insert manually? This may get you the exact syntax required for an
external
link.

Mike F"Dave" wrote in message

...



Hello. I fear I may be running into a limitation of VBA, but figured
I'd check with the gurus to see if I'm doing anything silly.

When I manually insert a photo (Insert | Picture | <filename) in
Excel (Office 12), it allows me to use an URL for my filename (eg.
http://www.seattlesmiths.com/photos/codi1.jpg). However if I try to
use an URL in my macro (ie ActiveSheet.Pictures.Insert("http://
www.seattlesmiths.com/photos/codi1.jpg")) it gives me the following
error:

"Unable to get the insert property of the Pictures class"

If I use a local photo, the call works correctly. Any ideas on how to
programatically insert a photo using an URL rather than a local file?

Thanks!
Dave- Hide quoted text -

- Show quoted text -
thanks for your response.

Strangely, when I use the macro recorder it just creates an empty
macro. this occurs both for inserting a local picture, and when I use
the URL.