Automate Download From a server

ethcybo

New Member
Joined
Sep 7, 2017
Messages
1
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]
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
Can you connect to the data using Data\From Other Sources\Data Connection Wizard ?
If so, macro recording may provide useful insight.
 
Upvote 0

Forum statistics

Threads
1,223,227
Messages
6,170,848
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top