How can I get network userid in a cell in excel?

[Guest]

I am in need of some function or macro to populate a column in an excel
spreadsheet for existing rows with the user's network login id.

 

[Guest]

Add this code to a standard module in your project. You can then just add the
formula =loginid() to the cell that you want to display the user name...

public function LoginId() as string
application.volatile
LoginID = Environ("UserName")
end function

 

[tony h]

environ("USERNAME")