Computer name in vba

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

 

[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