Helpp - Excel VBA check HTTP authetication Login

[sergioljm]

Hello Guys, I’m Sergio

Hope someone can help me; I work for a local Maintenance Telecomunication company in Brazil.

My problem, we are responsible for the maintenance of 144 internal security system (internal equipment CCTV, dor alarms)

Everyday a new Login and Password is automatically set (the same for the 144 Sites). I’m responsible to check and report to security area every day login and password were changed. Today I need to do this one by one

The authentication is a http basic authentication , and the Address are IP’s.

I also don’t need enter in the webpage, I just need to know if the new password is set. Just need to know if the authentication is ok for the new password

My report and test table is simple -

- 3 Column A, B, C
- 144 IP's line
- The daily Login and Password

[TABLE="width: 368"]
<tbody>[TR]
[TD][/TD]
[TD]Day Password
[/TD]
[TD]29/08/2016
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Login
[/TD]
[TD]xpto
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Password
[/TD]
[TD]xpto
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]nº
[/TD]
[TD]IP (example)
[/TD]
[TD]Status
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]183.21.51.218:81
[/TD]
[TD]Changed
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]183.21.51.219:81
[/TD]
[TD]Changed
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]183.21.51.220:81
[/TD]
[TD]Changed
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]183.21.51.221:81
[/TD]
[TD]Fail
[/TD]
[/TR]
[TR]
[TD]...
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 368"]
<tbody>[TR]
[TD]144
[/TD]
[TD]183.21.51.222:81
[/TD]
[TD]Fail
[/TD]
[/TR]
</tbody>[/TABLE]


I hope some VBA could help me, is that possible?

Thanks for all help.


Sergio