Serial Number

  • Thread starter Thread starter Guest
  • Start date Start date
and which serial number did you have in mind?
drive/networkcard etc...

following will give you serial of a drive

Function GetDriveSerial&(Drive$)
With CreateObject("Scripting.FileSystemObject")
On Error Resume Next
With .GetDrive(Drive)
Stop
If .IsReady Then
GetDriveSerial = Abs(.SerialNumber)
Else
GetDriveSerial = -1
End If
End With
On Error GoTo 0
End With
End Function

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Jason Zischke wrote :
 
If you're looking for the PC's serial number, you can use WMI. You
need to have admin rights to run this though...

Sub serial()
strComputer = "."
Set objWMIService = GetObject("winmgmts:" _
& "{impersonationLevel=impersonate}!\\" & strComputer &
"\root\cimv2")
Set colSettings = objWMIService.ExecQuery _
("Select * from Win32_BIOS")
For Each objBIOS In colSettings
MsgBox objBIOS.SerialNumber
Next
End Sub
 
Back
Top