When I import external data from the web, I find that the pictures are all
gone. Is there anyway to include the pictures in the import?

In fact, if I have a link which is something like this
http://www.abc.com/1234.jpg, how can I import this jpg file into Excel,
using VBA or otherwise?

Thanks!

With ActiveSheet.Pictures
.Insert("http://www.abc.com/1234.jpg")
End With

Tim.

--
Tim Williams
Palo Alto, CA


"Shatin" wrote in message
...
When I import external data from the web, I find that the pictures are all
gone. Is there anyway to include the pictures in the import?

In fact, if I have a link which is something like this
http://www.abc.com/1234.jpg, how can I import this jpg file into Excel,
using VBA or otherwise?

Thanks!

Tim,

Many thanks for such a prompt response!


"Tim Williams" <timjwilliams at gmail dot com wrote in message
...
With ActiveSheet.Pictures
.Insert("http://www.abc.com/1234.jpg")
End With

Tim.

--
Tim Williams
Palo Alto, CA


"Shatin" wrote in message
...
When I import external data from the web, I find that the pictures are
all
gone. Is there anyway to include the pictures in the import?

In fact, if I have a link which is something like this
http://www.abc.com/1234.jpg, how can I import this jpg file into Excel,
using VBA or otherwise?

Thanks!