Show computer user name 2

[JAES]

I know this is right in front of me but I can't figure out how to get the computer name or login name into a string. Any help is appreciated.

 

[HarleyQuinn]

faq222-429 should do the trick.

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[PHV]

In VBA: Environ("COMPUTERNAME") and Environ("USERNAME")
(Assumptions: no win9x ...)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[HarleyQuinn]

I still prefer the API calls over ENVIRON if at all possible, as the Environmental setting can be modified easily at runtime, causing possible problems.

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[JAES]

Thanks guys, I appreciate the help, as always.