Finding the Username of a user who has a shared Network file open.

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

How can I find the Username of the user who has a shared
network Excel file open, using VBA.
 
Hi Ken,
Sub UsersList()
Dim users, msg As String
users = Workbooks("MyBook.xls").UserStatus
For Row = 1 To UBound(users, 1)
msg = msg & users(Row, 1)
Next
MsgBox msg, 64
End Sub

Regards,
MP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Writing Data to an External File 3
File sharing 6
Access Control With UserName 2
File in use by ? WHO ????? 2
Windows API to get network username of person with file open 7
Shared Workbook 1
Please help with "Username" 13
Forgot Username Feature 0

Back
Top