PDA

View Full Version : [SOLVED] Macro to get HD info or computer name?



Johnlemons
07-27-2005, 10:08 AM
Anyone know the command in excel to get the hard driver serial #.
or maybe even the computer name?

Thanks,
John.

Jacob Hilderbrand
07-27-2005, 10:13 AM
Try this:



MsgBox Environ("COMPUTERNAME")
MsgBox Environ("HOMEDRIVE")


Not sure about the serial number for the hard drive.

Zack Barresse
07-27-2005, 10:19 AM
From our KB: http://www.vbaexpress.com/kb/getarticle.php?kb_id=234

Johnlemons
07-27-2005, 11:33 AM
Thanks guys for the quick reply. This worked like a charm.

John.

Jacob Hilderbrand
07-27-2005, 12:37 PM
Glad to help. :beerchug:

Take Care