Closed Thread
Results 1 to 3 of 3

Import pictures from the web

  1. #1
    Shatin
    Guest

    Import pictures from the web

    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!




  2. #2
    Tim Williams
    Guest

    Re: Import pictures from the web

    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!
    >
    >
    >




  3. #3
    Shatin
    Guest

    Re: Import pictures from the web

    Tim,

    Many thanks for such a prompt response!


    "Tim Williams" <timjwilliams at gmail dot com> wrote in message
    news:uolHJLZrFHA.304@TK2MSFTNGP11.phx.gbl...
    > 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!
    > >
    > >
    > >

    >
    >




Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1