×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

How to get Hard Drive Serial Number by Manufacturer with VBA
4

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

RE: How to get Hard Drive Serial Number by Manufacturer with VBA

CODE

MSGBOX ("Please save your work, turn off the computer, open the case, write down the serial number of the hard drive, reinstall the case, start up the computer and restart this application.")

 

RE: How to get Hard Drive Serial Number by Manufacturer with VBA

(OP)
Dear MintJulep

I want to read that number through Excel VBA.

Thanks

RE: How to get Hard Drive Serial Number by Manufacturer with VBA

2
Dear nitin36537

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

There are freeware utilities that find the hard disc ID. Maybe you can activate them through Excel and extract the ID.

RE: How to get Hard Drive Serial Number by Manufacturer with VBA

Quote (IDS):

I can't be sure, but I think MintJulep may have been making a little joke.
It made me laugh; if it was a joke, well done MintJulep!
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

Clyde - your file works on my computer with no problems (Excel 2010 and Windows7), after enabling macros.

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

IDS's UDF works fine for me as well, using Excel 2002 on Win-XP.

(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

I think the reference to the Office Object Library and/or the Excel Object Library are probably the key things to ensuring it works.

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

Doug,
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.

View Clyde's profile on LinkedIn

RE: How to get Hard Drive Serial Number by Manufacturer with VBA

Doug,
The file works just fine on my PC (Vista/Excel 2007) where I have administrative rights.  Thanks for your help.

 

View Clyde's profile on LinkedIn

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources