Consulting

Results 1 to 5 of 5

Thread: Macro to get HD info or computer name?

  1. 07-27-2005, 10:08 AM #1
    Johnlemons
    Johnlemons is offline
    VBAX Regular
    Joined
    May 2005
    Posts
    18
    Location

    Macro to get HD info or computer name?

    Anyone know the command in excel to get the hard driver serial #.
    or maybe even the computer name?

    Thanks,
    John.
    Reply With Quote Reply With Quote
  2. 07-27-2005, 10:13 AM #2
    Jacob Hilderbrand
    Jacob Hilderbrand is offline
    Site Admin
    Jedi Master         VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    Try this:


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

    Not sure about the serial number for the hard drive.



    Reply With Quote Reply With Quote
  3. 07-27-2005, 10:19 AM #3
    Zack Barresse
    Zack Barresse is offline
    Site Admin
    Urban Myth
     VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location
    From our KB: http://www.vbaexpress.com/kb/getarticle.php?kb_id=234
    Regards, Zack Barresse

    Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
    What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
    Reply With Quote Reply With Quote
  4. 07-27-2005, 11:33 AM #4
    Johnlemons
    Johnlemons is offline
    VBAX Regular
    Joined
    May 2005
    Posts
    18
    Location
    Thanks guys for the quick reply. This worked like a charm.

    John.
    Reply With Quote Reply With Quote
  5. 07-27-2005, 12:37 PM #5
    Jacob Hilderbrand
    Jacob Hilderbrand is offline
    Site Admin
    Jedi Master     VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    Glad to help.

    Take Care



    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules