Hey guys need ur help I want to Automate MS Excel. I want a macro to download pics from web site and store in other file...Suppose Sourcepic.xls when I open should be able to run a workbook open event macro which will download a picture from a website which I specify (http://site.com/abc.jpg) and save in some other excel file resultpic.xls.the name of resultant file shud be provided by me using a text box.Help will be appreciated

Thanks
Saleh