Get windows username vba

Continue No Comments. Continue 3 Comments. Terms and Conditions of use. Home About Advertise With Us. Newsletter Get latest updates from exceltip in your mail. Powered by GDPR plugin. Privacy Overview This website uses cookies so that we can provide you with the best user experience possible. You can adjust all of your cookie settings by navigating the tabs on the left hand side. Strictly Necessary Cookies Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.

Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually.

Linked Related 5. Hot Network Questions. Question feed. Stack Overflow works best with JavaScript enabled. Accept all cookies Customize settings. Design a login userform and display it on the open event of the workbook. Based on the credentials, you can control the access on the data 2.

Instead of using login userform, you can get the system login user id and control the access on the data. Open an Excel file 2. Paste the code in the module 5. Now add a shape in Excel sheet 6. Does not work with Azure joined computers.

Your email address will not be published. Network object. Unlike environment variables, this can not easily be spoofed. The code to do so would look like:. Another approach, more convoluted however, is to use WMI to list the active sessions and then cross-reference the session with the logged in username. It can be done by doing something along the lines of:. Name If dictUsers. Print User Next End Sub. Below is a very well known API that was written by Dev Ashish that I tweaked to make it compatible with x32 and x64 usage.

This is a good run down of various ways to get the users Windows login name, but often that name is cryptic numeric or abbreviated. A user will recognize their own name but not other peoples names.

Like Dmitriy Sonnikh, I wanted a way to get the friendly display name that is stored in Active Directory. This makes it easy for any user to identify the person who made the last change. Use the current user name. ErrorHandler: If err. Return the passed name. A few notes: — This routine can be slow, especially if you are not connected to the domain.