ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Looking for network-username with Excel macro (https://www.excelbanter.com/excel-programming/312383-looking-network-username-excel-macro.html)

Geert Nauta

Looking for network-username with Excel macro
 
Hi there,
Could anyone please tell me how to pick up with a macro,
the username on a workstation in a network. (NOT the
username as used for MS-Office!)
Why? I am building a program to place textfiles with data
from various workstations to the server. These textfiles
should carry the name of the user that is logged into the
network at that moment on that workstation.

Thanks,
Geert Nauta

Geert Nauta[_2_]

Looking for network-username with Excel macro
 
Thanks Norman.
Does excactly what I want.
regards
Geert

-----Original Message-----
Hi Nauta,

Michel Pierron recently suggested:

MsgBox CreateObject("Wscript.Network").UserName


---
Regards,
Norman



"Geert Nauta" wrote in message
...
Hi there,
Could anyone please tell me how to pick up with a macro,
the username on a workstation in a network. (NOT the
username as used for MS-Office!)
Why? I am building a program to place textfiles with

data
from various workstations to the server. These textfiles
should carry the name of the user that is logged into

the
network at that moment on that workstation.

Thanks,
Geert Nauta



.



All times are GMT +1. The time now is 05:46 PM.

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