Automate Download From a server

[ethcybo]

Hi All,
I am new to VBA Coding I am stuck on a coding in vba.

I have to go a web page eg.(http://120.12.34.65/instarecoder) then a login window prompted i have fill user id and password there. after that a main page appear there i have to click on check box, some box appear below check box and i have to put there "Start Time, End time, From Date & To Date" then submit it.

in next page i have to click download all then my download starts. I have to do it 12 times.

so far i figured out what is the direct link to "Download All" Button but problem is when is there is no further link to get direct file so i have to click that button every time in vba also.

so can any one help me to design a vba which work on background to download and save the files while I continue my normal work.

Thanks in advance

link example is : (it changes only my given time and date)
1.

http://121.00.00.00/instacorder/Dump.aspx?ANI=&DNIS=&StartDate=2017-09-04+09%3a00%3a00&EndDate=2017-09-04+10%3a00%3a00&DBName= .....(i can not give full link it confidential)

<colgroup><col width="64"></colgroup><tbody>
</tbody>

2.

http://121.00.00.00/instacorder/Dump.aspx?ANI=&DNIS=&StartDate=2017-09-04+10%3a00%3a00&EndDate=2017-09-04+11%3a00%3a00&DBName=(i can not give full link it confidential)

<colgroup><col width="64"></colgroup><tbody>
</tbody>

 

[SpillerBD]

Can you connect to the data using Data\From Other Sources\Data Connection Wizard ?
If so, macro recording may provide useful insight.