I want to automate the downloading of a file from the following url through vba
http://www.mcxindia.com/sitepages/BhavCopy.asp
For manual downloading, I need to go on that page then select a date say 21.04.2011 using the given button and then click on "go" button and then click on the hyper link "view in excel"
Now I want to automate this using vba. Is there a way to do it?
Bookmarks