I would like to authenticate one of my Excel Application against the Windows
Username and Password. I have found out how to get the Username, but I am
unable to find anything on the password.

Does anyone know how to authenticate against the Windows password?

Thanks,
Robert

Robert,

You could pick up on a technique shown on Randy Birch's site for
'Authenticating a User though the NT Challenge Process'. You can find it at
http://vbnet.mvps.org/, and search for the title I just gave you.

To quote the page into '...Windows users in a corporate environment are
familiar with the NT Challenge procedure .. they call it logging on. In a
nutshell, the NT Challenge attempts to confirm the credentials entered by
the user against security information on the login machine - the local
workstation or domain server. When the challenge is successful, the login
continues; when it is not, the user's attempted login count is incremented
by one until the administrator-defined account lockout point is reached.
....'

But be warned, it is not simple, and you will need to adapt his code to your
app. I hope you aren't expecting a simple solution.

--
HTH

Bob Phillips

"cmart02" wrote in message
...
I would like to authenticate one of my Excel Application against the
Windows
Username and Password. I have found out how to get the Username, but I am
unable to find anything on the password.

Does anyone know how to authenticate against the Windows password?

Thanks,
Robert

Bob,

Thanks for the message.

No, I was not expecting anything simple, but from what I have already seen,
it should not be defficult to adapt to VBA.

I did not know the site and it has great resources, so I thank you for that
too!!!

Best regards,
Robert

Robert,

You are right, but I know a lot of people would be frightened by all that
code, and the technical bent of it :-). I know it works, as I use it myself
in VBA.

It is a great site, and whilst it is really aimed at VB, there is loads that
can be adapted to VBA.

Good luck with it

Bob

"cmart02" wrote in message
...
Bob,

Thanks for the message.

No, I was not expecting anything simple, but from what I have already
seen,
it should not be defficult to adapt to VBA.

I did not know the site and it has great resources, so I thank you for
that
too!!!

Best regards,
Robert