Administrator Recognision

[Acoustic]

does anyone know if it is possible for excel to recognise who is logged in to a computer through a work server setup??

 

[Tom Urtis]

Generally, to get the user name displayed in the Options dialog, use Application.UserName. To get the network user name, use Environ("UserName"). Note, that's generally...a lot can be happenning with this work server setup you are referring to, and it's feasible that a more elaborate approach would be needed if teh above tactics do not work. Hard to diagnose from a distance where network configurations are concerned.

 

[chicagodiceman]

I used to use this a lot:

Environ("UserName")

Basically, it helped me limit who could run macros but on a network, it does provide you with the information I think you are looking for.

I see Tom beat me to the answer but I agree on the limitations he mentions...

 

[Acoustic]

cheers for the quick response guys, i am rather new to excel and i figured you meant in a cell to type =Environ("UserName")

is this correct or am i just retarded haha
cheers

btw excel 2003

 

[chicagodiceman]

Sorry, didn't see that you are a new member so first off, Welcome to the Board!

No, placing this in a cell would not serve any purpose, this needs to be included in a macro, in the VBA editor. Please let us know if you need further assistance.

 

[brettdj]

No. It is VBA

Are you looking to determine this on the local machine, or over a network?

Cheers

Dave

 

[Acoustic]

well, the computers that everyone has connects up to a server so i am presuming its a server.

 

[Acoustic]

All good guys, i sorted it, was just putting the code in the workbook instead of the general module....cheers

 

[brettdj]

well, the computers that everyone has connects up to a server so i am presuming its a server.

What I meant was are you looking to return the username of the computer hosting the code (local computer), or were you looking to connect to a separate computer elsewhere on the network and grab the logged on user from there

From your last response it was the former.

Good to hear you are sorted

Cheers

Dave

 

[ShieBoon]

Hi all, i have a similar need to track all the users who are accessing the file. However, the users access the file from Sharepoint. Is there anyway i can still do so?

Thanks!