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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.