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

Tim.

--
Tim Williams
Palo Alto, CA


"Shatin" <lk1439-newsgroup@yahoo.com.hk> wrote in message
news:eCPE6DZrFHA.1788@tk2msftngp13.phx.gbl...
> 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!
>
>
>