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
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