[RESOLVED] return system logon name of user in vba

**mikeymay** · Jan 17th, 2006, 09:31 AM

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.

**salvelinus** · Jan 17th, 2006, 10:08 AM

Use the API GetUserName

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

**RobDog888** · Jan 17th, 2006, 10:35 AM

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

**mikeymay** · Jan 17th, 2006, 10:42 AM

Fantastic!

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

**zaza** · Jan 17th, 2006, 02:28 PM

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

zaza

**RobDog888** · Jan 17th, 2006, 02:31 PM

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

**RobDog888** · Jan 17th, 2006, 02:32 PM

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

**zaza** · Jan 17th, 2006, 02:35 PM

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

zaza

Thread: [RESOLVED] return system logon name of user in vba

Thread Tools

Display

[RESOLVED] return system logon name of user in vba

Re: return system logon name of user in vba

Re: return system logon name of user in vba

Re: return system logon name of user in vba

Re: [RESOLVED] return system logon name of user in vba

Re: [RESOLVED] return system logon name of user in vba

Re: [RESOLVED] return system logon name of user in vba

Re: [RESOLVED] return system logon name of user in vba

Posting Permissions