Windows Password

[Guest]

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 Phillips]

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.

 

[Guest]

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

 

[Bob Phillips]

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