Computer name in vba

  • Thread starter Thread starter David Mc
  • Start date Start date
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.
 
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
 
Back
Top