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

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

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

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