How can I find the Username of the user who has a shared network Excel file open, using VBA.
K Ken Sep 9, 2004 #1 How can I find the Username of the user who has a shared network Excel file open, using VBA.
M Michel Pierron Sep 10, 2004 #2 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
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
