http post from excel - user authentication from excel to web
 

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

http post from excel - user authentication from excel to web
 

Hi,

Look for Microsoft's WinHTTP Services.

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

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"bruce" wrote:

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

http post from excel - user authentication from excel to web
 

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



"Chris Marlow" wrote:

Hi,

Look for Microsoft's WinHTTP Services.

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

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"bruce" wrote:

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

http post from excel - user authentication from excel to web
 

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.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"bruce" wrote:

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



"Chris Marlow" wrote:

Hi,

Look for Microsoft's WinHTTP Services.

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

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"bruce" wrote:

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