ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to find Windows login name with code? (https://www.excelbanter.com/excel-programming/365908-how-find-windows-login-name-code.html)

SupperDuck

How to find Windows login name with code?
 
Dear all,

In my macro i want to get the login name.

For example, when i make a record macro, it writes "this macro was created
by superduck which is my login name on windows.

But i don't know how to do this with code :(

Regards,



Paul Lautman

How to find Windows login name with code?
 
SupperDuck wrote:
Dear all,

In my macro i want to get the login name.

For example, when i make a record macro, it writes "this macro was
created by superduck which is my login name on windows.

But i don't know how to do this with code :(

Regards,


Well here's a strange thing. I just went to a search engine that you may
have heard of called Google and typed in:
vba windows login name
And the very top result returned was:
Function to return various Environment Names | Excelguru.ca The formula can
also be called in VBA in the same manner. For example:; msgbox
getname("windows") or msgbox getname(2) will return the Windows login name
....
excelguru.ca/node/2 - 32k - Cached - Similar pages


If you haven't heard of Google I suggest that you take a look, it tends to
be able to find lots of useful things like this in seconds.




All times are GMT +1. The time now is 07:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com