Computer name in vba

D

David Mc

How can i find the name of a computer by using vba and
return as a string.

David

ps. i do not want the username but the machine name.
 
J

Juan M. Afan de Ribera

In addition to what Allen says, you can also use Windows Scripting, ie:

Dim objnet As Object

Set objnet = CreateObject("WScript.Network")
MsgBox objnet.ComputerName & " - " & objnet.UserName
Set objnet = Nothing
 
Top