VBA Multi user information

David Kuruc 1 Reputation point
2021-06-30T07:54:23.99+00:00

Hello,

I would like to ask, is there any commands or library for VBA to get information from multi-user excel status? (Maybe this is information from SharePoint, or teams. I'm mot sure)

More specific, I can see name and location where is active my college.

Is any way to get this information for VBA, so i can work with that in code?

Thank you

In picture, there you can see my name in top right and my location in green A4

My college is online, there is his name, and you can see his cell on C4 - color pink.

110487-test.png

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,508 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bob Larson (Access MVP 2008, 2009, 2011) 251 Reputation points
    2021-07-06T01:16:09.69+00:00

    Look into ThisWorkbook.UserStatus

    111973-2021-07-05-18-14-29.jpg

  2. Bob Larson (Access MVP 2008, 2009, 2011) 251 Reputation points
    2021-07-06T14:11:56.017+00:00

    Well, that's about the only thing you have available to you unless you use VBA to add a custom property to the workbook and then update the property via VBA in the On Open and BeforeClose events. Unless someone else knows something I don't.

    0 comments