Automate Authentication

User avatar
agibsonsw
SilverLounger
Posts: 2403
Joined: 05 Feb 2010, 22:21
Location: London ENGLAND

Automate Authentication

Post by agibsonsw »

Hello.
A colleague is using VBA and a http request to obtain data from a web page.
But the https page requires Authentication. Is it possible to supply certificate details programmatically? Thanks, Andy.
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.

User avatar
Jan Karel Pieterse
Microsoft MVP
Posts: 656
Joined: 24 Jan 2010, 17:51
Status: Microsoft MVP
Location: Weert, The Netherlands

Re: Automate Authentication

Post by Jan Karel Pieterse »

Sometimes you can include the credentials in the url:

Code: Select all

www.somesite.com/somepage.asp?user=JohnDoe&password=drowssap
Regards,

Jan Karel Pieterse
Excel MVP jkp-ads.com