Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to save pictures from the web to local hard drive
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to save pictures from the web to local hard drive
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" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to save pictures from the web to local hard drive
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" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to save pictures from the web to local hard drive
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" wrote in message ... 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" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to save pictures from the web to local hard drive
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to save pictures from the web to local hard drive
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Links to mapped drive change to refer to local hard drive | Links and Linking in Excel | |||
When I save a file on the hard-drive, it is fine, I can re-open, | Excel Discussion (Misc queries) | |||
Can I save to hard drive AND my flash drive at the same time? | Excel Discussion (Misc queries) | |||
On hard drive, how do I restore .XLS prior to last save? | Excel Programming | |||
Userform Local Drive & Network drive question | Excel Programming |