displaying username 1

[Luis939]

Just out of curiousity, is it possible to display the username of the user that is correctly logged onto the system. We use windows 2000 Professional here at our network so I was wondering how i would output that name into a msgbox thanks!!

 

[Loomah]

Hi
msgbox environ("username&quot should do the trick.
It's a while since I've used it so you may need to check username is one word. use the set command in dos to see the full list of available environment variables.

happy friday
;-)

If a man says something and there are no women there to hear him, is he still wrong?
The faqs ma'am, just the faqs. Get the best from these forums : faq222-2244

 

[xlbo]

Loomah - yup - all one word - To see all environment variables, run this:
Sub env()
Dim EnvString As String
Indx = 1
Do
EnvString = Environ(Indx)
Cells(Indx, 1) = EnvString
Indx = Indx + 1
Loop Until EnvString = ""
End Sub

Rgds, Geoff
Si hoc legere scis, nimis eruditionis habes
Want the best answers to your questions ? - then read me baby one more time - faq222-2244

 

[Loomah]

Sweeeeeeeeeeet!
Still, the DOS cmd does me - just on my lil ol' win95 stanalone home PC there's no need for username so it doesn't exist on the system!

"Abramovich, gizza tenner"
;-)

If a man says something and there are no women there to hear him, is he still wrong?
The faqs ma'am, just the faqs. Get the best from these forums : faq222-2244

 

[Luis939]

Your beautiful!!! thanks!