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

	Day Password	29/08/2016
	Login	xpto
	Password	xpto
nº	IP (example)	Status
1	183.21.51.218:81	Changed
2	183.21.51.219:81	Changed
3	183.21.51.220:81	Changed
4	183.21.51.221:81	Fail
...

<tbody>
</tbody>

144

183.21.51.222:81

Fail

<tbody>
</tbody>

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

Thanks for all help.


Sergio