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.
[TABLE="width: 64"]
<colgroup><col width="64"></colgroup><tbody>[TR]
[TD="width: 64"]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)
[/TD]
[/TR]
</tbody>[/TABLE]
2.
[TABLE="width: 64"]
<colgroup><col width="64"></colgroup><tbody>[TR]
[TD="width: 64"]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)
[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 64"]
<colgroup><col width="64"></colgroup><tbody>[TR]
[TD="width: 64"]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)
[/TD]
[/TR]
</tbody>[/TABLE]
2.
[TABLE="width: 64"]
<colgroup><col width="64"></colgroup><tbody>[TR]
[TD="width: 64"]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)
[/TD]
[/TR]
</tbody>[/TABLE]