Hi,
I want to download data from below URL : http://portal.amfiindia.com/NavHisto...=20&scm=102594
Upon opening this URL, there is data table with 4 columns. Out of that I need only column 4 (i.e. Date : that should be first column in excel) and column 1 (i.e. Net Asset Value : that should be second column in excel) data to get downloaded in attached excel. Is it possible?
In this URL parameters will be dynamic, but I can manage to get the same done on my own.
Can someone help with VBA code to do this???
Bookmarks