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

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.

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

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
--
HTH...

Jim Thomlinson


"Kalpana_Kar" wrote:

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.

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

environ("USERNAME")


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=527842