Check the over picture that shows the results from my pc (3 drives, one of which is a USB commute) when omitting the WHERE clause in the VBA program code.Įnd Subwoofer Downloads The document can become opened up with Excel 2007 or newer. If the WHERE term is disregarded, the details from all the travel objects will become gathered (y.g. When querying fór all the objects that fit in to the specific class, a WHERE offer is utilized to limit the lookup on USB pushes just (WHERE InterfaceTypeUSB). VBA code for reading through the serial quantity from a USB travel The program code is centered on the Win32DiskDrive WMI course, which signifies a actual physical disk commute as observed by a personal computer operating the Home windows operating program. One could become tempted to make use of the Gain32USBController course, which manages the abilities of a common serial tour bus (USB) controller.Īlthough this course seems very appropriate, it will not show any serial number property, so a various class is definitely required. The interesting part of this situation study had been the WMI course that acquired to become used. In the recent, we possess seen many code good examples on how to create WMI-reIated scripts in VBA, such as for setting the default Windows printer, getting battery information, joining a C0M DLL, retrieving á Macintosh address, and several others.

Get Hard Drive Vba Pc Software Subscribe.Sn = 'Serial Number: ' & objSMBIOS.SerialNumberĪn = 'Asset Tag: ' & objSMBIOS. Pn = 'Part Number: ' & objSMBIOS.PartNumber Set colSMBIOS = objWMIService.ExecQuery _ Set objWMIService = GetObject('winmgmts:' _ The serial number is presented in a text box which allows you to copy and paste it into another window.ĭownload MyHostName = InputBox ('Enter Machine Name') When you run the script it will prompt for the computer name:Īfter entering the computer name and pressing ‘OK’ it will return the part number, serial number and asset tag (if saved to the system BIOS). The following script can be used to remotely access the serial number for a computer on your network.

Get hard drive serial number vba