http post from excel - user authentication from excel to web

[Guest]

Hi

I am trying to build in authentication to my excel spreadsheet - the idea is
that a user will type in their username and password and that information
gets posted to an asp page which authenticates them against a database and
returns a +OK or -ER and based on that value I either let them continue or
not. Is something like this possible?

Any ideas would be much appreciated.

thanks
Bruce

 

[Guest]

Hi,

Look for Microsoft's WinHTTP Services.

I've posted some code that uses this library before.

Regards,

Chris.

 

[Guest]

Great, thanks Chris. I have managed to get a simple version working. Thanks
for your help!

If I may sneak in another quetion, any idea how to make a field in excel
appear like a password field (as they type only * or • appears but the value
is retained)?

thanks
Bruce

 

[Guest]

Bruce,

Rather than collect this in a cell I'd use an Excel Userform which has a
Textbox that has the property 'PasswordChar' set.

Regards,

Chris.