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.