Get Computer name in VB code

bobexcelvb · Aug 5, 2004

How do I get the current Computer Name (or Workstation name) that an Excel VB module is running under?

Thanks
Bob

cLFlaVA · Aug 5, 2004

Hi Bob-

Try the Environment variables:

Code:

Msgbox VBA.Environ("COMPUTERNAME")

*cLFlaVA
----------------------------
A polar bear walks into a bar and says, "Can I have a ... beer?"
The bartender asks, "What's with the big pause?

PHV · Aug 6, 2004

If you're on a win9x box the %COMPUTERNAME% environment variable doesn't exist.
You may try something like this:
Set N = CreateObject("WScript.Network")
MsgBox "Computer Name = " & N.ComputerName
Set N = Nothing

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

bobexcelvb · Aug 6, 2004

Thanks, these samples work great.

Bob

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Get Computer name in VB code

bobexcelvb

MIS

cLFlaVA

Programmer

PHV

MIS

bobexcelvb

MIS

Similar threads

Part and Inventory Search

Sponsor