[RESOLVED] return system logon name of user in vba

Is there anyway of returning the network logon name of a user using a macro.

I have a list of people who can authorise a user form but are required to input a password to cpmlete authorisation.

I want to then check this password against a password entered on an excel file that has been saved to that users own folder on the network and to which only they have access premission.


Thanks all.

Use the API GetUserName

http://www.mentalis.org/apilist/GetUserName.shtml

Or here in our VB FAQ Forum. - http://www.vbforums.com/showthread.php?t=357723

Fantastic!

Never imagined it would be so simple........

Do I misunderstand? Or is Application.Username what you want...?


zaza

Thats the Office VBA username and not the Windows username. They are two different names I believe.

Like in Excel, that would be the File > Properties > Author property and not Windows logon username.

Ah. For all the people using my spreadsheet, these are one and the same...


zaza