How to get Hard Drive Serial Number by Manufacturer with VBA
How to get Hard Drive Serial Number by Manufacturer with VBA
(OP)
How to get the Hard Drive Serial Number given by the Manufacturer with VBA?
Please note that I need Number given by Manufacturer & not Hard drive serial number which is a random number that is generated by DOS or Windows every time you format your hard drive.
Thanks
Please note that I need Number given by Manufacturer & not Hard drive serial number which is a random number that is generated by DOS or Windows every time you format your hard drive.
Thanks





RE: How to get Hard Drive Serial Number by Manufacturer with VBA
CODE
RE: How to get Hard Drive Serial Number by Manufacturer with VBA
I want to read that number through Excel VBA.
Thanks
RE: How to get Hard Drive Serial Number by Manufacturer with VBA
I can't be sure, but I think MintJulep may have been making a little joke.
Your question is answered in the other thread.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: How to get Hard Drive Serial Number by Manufacturer with VBA
RE: How to get Hard Drive Serial Number by Manufacturer with VBA
If it wasn't a joke, well done anyway.
(no, the star wasn't from me)
RE: How to get Hard Drive Serial Number by Manufacturer with VBA
http://www.diskserialnumber.com/
h
"Wildfires are dangerous, hard to control, and economically catastrophic."
Ben Loosli
RE: How to get Hard Drive Serial Number by Manufacturer with VBA
http:/
is in VBA (not VB.net), is much simpler, and does not require any external utilities.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: How to get Hard Drive Serial Number by Manufacturer with VBA
From the other thread:
I have tried this and failed (see attached)..
If you have the time, could you help?
RE: How to get Hard Drive Serial Number by Manufacturer with VBA
I have attached a screenshot showing the referneces I have running (Tools-references in the VB Editor). Check you have all of those enabled.
Another possible problem might be if you are not running as administrator.
Other than that I can only suggest following the discussions linked previously and see if anyone has had the same problem, or try one of the other solutions.
Please let us know if you get it fixed or not.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: How to get Hard Drive Serial Number by Manufacturer with VBA
(However. I have made a small spreadsheet that incorporates the UDF in a code module. When I take that spreadsheet to a new computer and load it up, the new disk serial number does not come up automatically. Nor does it come up if I hit <F9>. I have to actually "edit" the cell that contains the call to the UDF to get the new serial number appearing. It seems that the UDF is somehow slipping through Excel's normal recalc logic.)
RE: How to get Hard Drive Serial Number by Manufacturer with VBA
Beacuse it doesn't have any parameters it won't be in the recalc loop. Either entering edit mode (press F2 with the function cell selected) then enter, or Ctrl-Alt-F9 to do a full recalc should make it update.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: How to get Hard Drive Serial Number by Manufacturer with VBA
Thanks, I'm using Windows XP and Excel 2007. I do have all of the references enabled. I do not have administrative privliges on this PC. I'll check at home or have our administrator try it here.
RE: How to get Hard Drive Serial Number by Manufacturer with VBA
The file works just fine on my PC (Vista/Excel 2007) where I have administrative rights. Thanks for your help.