PDA

View Full Version : Downloading file from internet



amanpadia1
07-07-2006, 04:40 AM
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 (http://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
07-07-2006, 06:15 AM
Hi.

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

Thanks

lucas
07-07-2006, 07:58 AM
Here is a good discussion on downloading files from the internet to get you started:
http://www.vbaexpress.com/forum/showthread.php?t=8141&highlight=download

compariniaa
07-07-2006, 07:58 AM
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