+ Reply to Thread
Results 1 to 8 of 8

Users Online?

  1. #1
    Registered User
    Join Date
    10-08-2006
    Posts
    68

    Smile Users Online?

    I think I might have bitten off more then I could chew agreeing to do this project but I was hoping that I could get some ideas from you great users.
    I am trying to develop a workbook that users at my job can basically click a button to let us know that they're online and click another button to let us know that they are offline. I was hoping that there would be an option that it would keep track of the time that the user is online so we can keep track of the time of our employees that work from home.

    Is anyone out there done anything like this before or have any ideas for me?
    All help is greatly appreciated.
    Thanks
    Nate

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    The attached workbook has some functionality which will get you started.
    Attached Files Attached Files
    Martin

  3. #3
    Registered User
    Join Date
    10-08-2006
    Posts
    68
    Mrice,
    Thanks for your help, this looks almost exactly what I'm looking for.
    I've attached an example for what I would like the worksheet to look like.
    Unfortunatly I'm unfamiliar with the tools that you've used to create yours.

    Would you be kind enough to take the example that I've attached and add the macros to it?

    I'd like to learn about adding the username of the computer and how you created this. Could you please help me out or point me in the rite direction with keywords for searching for help.

    All help is greatly appreciated.
    Nate
    Attached Files Attached Files

  4. #4
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    Version attached. The sheet you need to look at is Sheet2. I've removed most of the merging of cells as this was causing what appeared to be unnecessary complexity.

    The code for determining the user name was lifted straight from a google search.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    10-08-2006
    Posts
    68
    Mrice,
    This is perfect. Thanks.
    Is there any way to have the time clock paste always on row 4 and have all the other rows drop down so you can always view the newest users online?
    Thanks again
    Nate

  6. #6
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    Two ways -

    Insert a row at row 4 and paste into this or

    add at the bottom and sort by time

    The extra code for the first would be

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    10-08-2006
    Posts
    68
    mrice,
    Sorry, but I'm a little confused with your explination,
    Where exactly in the macros should add extra info?
    Nate

  8. #8
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    New version - some other mods need making which I've just spotted.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1