Downloading file from internet

[amanpadia1]

Hi

I need help on downloading multiple file from an internet website.

The site needs date in the following format (mm-dd-yyy) to donwload file for that particular date.

Once i click sumit , the file save dialog box appears and the url is as follows:

example : date 05-07-2006 the url is www.nseindia.com/content/historical/derivatives/2006/jul/fo06jul2006bhav.csv

This file is for 05-07-2006. Similarly i want to donwload multiple files giving different dates as input in the form of a loop.

Can someone help me automate this through a vba code.

I am a complete beginner at vba

Thanks

[amanpadia1]

Hi.

The date format should be (dd-mm-yyyy), and not mm-dd-yyy.

Thanks

[lucas]

Here is a good discussion on downloading files from the internet to get you started:
http://www.vbaexpress.com/forum/show...light=download

[compariniaa]

i'm a bit of a beginner myself, so I can't be a great help, but I found this online:

http://www.xcelfiles.com/Excel01.html

hope it helps