VBA to save pictures from the web to local hard drive

[mz]

Hi, I am looking for some help on how to save pictures from the web to local
hard drive with some VBA in Excel. I know that you can use the
activesheet.picture.insert to the pictures from the web, then save the
workbook as html. But this is not what I want. I want to have the ability
to save the pictures directly. Thanks in advance for any help.

[Anne Troy]

I believe Bob Phillips gave me some of this very code. You provide the link
on the web, and it downloads to a folder on the hard drive. Bob?
*******************
~Anne Troy

www.OfficeArticles.com


"mz" <[email protected]> wrote in message
news:[email protected]...
> Hi, I am looking for some help on how to save pictures from the web to
local
> hard drive with some VBA in Excel. I know that you can use the
> activesheet.picture.insert to the pictures from the web, then save the
> workbook as html. But this is not what I want. I want to have the
ability
> to save the pictures directly. Thanks in advance for any help.
>

[mz]

Yeah. That is exactly what I want. Can you please give me some hints before
Bob replies.

Thanks.

"Anne Troy" wrote:

> I believe Bob Phillips gave me some of this very code. You provide the link
> on the web, and it downloads to a folder on the hard drive. Bob?
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
>
>
> "mz" <[email protected]> wrote in message
> news:[email protected]...
> > Hi, I am looking for some help on how to save pictures from the web to
> local
> > hard drive with some VBA in Excel. I know that you can use the
> > activesheet.picture.insert to the pictures from the web, then save the
> > workbook as html. But this is not what I want. I want to have the
> ability
> > to save the pictures directly. Thanks in advance for any help.
> >
>
>
>

[michelxld]

Hello Mz , Hello Anne

I hope this help you

http://www.excelforum.com/showthread.php?t=384071


regards ,
michel

[Anne Troy]

I'm thinking Bob won't mind at all. (Keeping fingers crossed.)
http://www.officearticles.com/downlo...downloader.zip

*******************
~Anne Troy

www.OfficeArticles.com


"mz" <[email protected]> wrote in message
news:[email protected]...
> Yeah. That is exactly what I want. Can you please give me some hints
before
> Bob replies.
>
> Thanks.
>
> "Anne Troy" wrote:
>
> > I believe Bob Phillips gave me some of this very code. You provide the
link
> > on the web, and it downloads to a folder on the hard drive. Bob?
> > *******************
> > ~Anne Troy
> >
> > www.OfficeArticles.com
> >
> >
> > "mz" <[email protected]> wrote in message
> > news:[email protected]...
> > > Hi, I am looking for some help on how to save pictures from the web to
> > local
> > > hard drive with some VBA in Excel. I know that you can use the
> > > activesheet.picture.insert to the pictures from the web, then save the
> > > workbook as html. But this is not what I want. I want to have the
> > ability
> > > to save the pictures directly. Thanks in advance for any help.
> > >
> >
> >
> >

[mz]

Anne and michelxld,

Thanks. This really helps. Really appreciated your help.

MZ.

"michelxld" wrote:

>
> Hello Mz , Hello Anne
>
> I hope this help you
>
> http://www.excelforum.com/showthread.php?t=384071
>
>
> regards ,
> michel
>
>
> --
> michelxld
> ------------------------------------------------------------------------
> michelxld's Profile: http://www.excelforum.com/member.php...o&userid=17367
> View this thread: http://www.excelforum.com/showthread...hreadid=388190
>
>

[aaron1988]

HI, is there s way of changing the code in this file so doesnt download to a specific file but have another column called FolderNames then we have for each image like folder1 folder2 etc so it downloads to those specific folders not just 1 folder?

Thanks
Aaron