View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Steve Yandl
 
Posts: n/a
Default Formula to show PC name, or IP, or personal windows ID

It's part of VBA.

Create a macro like

Sub GetUserName()
MsgBox Environ("UserName")
End Sub

run and see what you get. Instead of creating a subroutine, you could write
a custom function and the variables would be available the same as standard
Excel functions.

Steve

"nkoichev" wrote in
message ...

There's no such a formulas in excel like "=environ("ComputerName")

=environ("UserName")" !?

The result is "#NAME?"!


--
nkoichev
------------------------------------------------------------------------
nkoichev's Profile:
http://www.excelforum.com/member.php...o&userid=30926
View this thread: http://www.excelforum.com/showthread...hreadid=506014