Get the computer name : Windows Resources « Windows API « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Windows API
  3. Windows Resources

Get the computer name

 

Private Declare Function GetComputerName Lib "kernel32" Alias "GetComputerNameA" (ByVal Buffer As String, Size As Long) As Long

Sub Main()
  Dim Buffer As String * 255
  Dim Result As Long
  Dim Length As Long

  Length = 255
  Result = GetComputerName(Buffer, Length)
  If Length > 0 Then ComputerName = Left(Buffer, Length)

End Sub








Related examples in the same category

1.Clipping and Unclipping the Cursor
2.The FindWindow() function finds the first top-level window in the window list that satisfies the specified arguments.
3.Check Whether an Excel File Is Open on a Network
4.Custom About Dialog
5.Disable the X for Closing a Userform
6.Check mouse button
7.Returns the Windows directory
8.Get execuatable file name from a given file name
9.Get screen width and height
10.Get window's rectangle
11.Find window by class name
12.Show Excel Window Size
13.Get color depth
14.Get DC and release it
15.Get user name
16.Freeze a window
17.Change the Excel icon