title: Access control for Excel files on FILR (Novell)
body: <p>We have just started using Filr as our file sharing platform, in short we have a seperate excel file for each of our shipments that we export and we have different users accessing these files although editing should never happen concurrently.</p>
  
  <p>I have no formal IT background, I am an accountant and I know the basics. I have over the last year started teaching myself VBA using trial and errors from what I find on platforms like these so I apologise for any ignorance :)</p>
  
  <p>The problem is that it seems Filr allows any excel files to be edited by multiple users, without any warning when opening the file and without the sharing capabilities being activated within excel. This is causing conflicting copies being created and confusion as to which is the correct file. I have tried to address this with the IT department (from our marketing company) managing Filr and am not getting any real assistance to address the problem.</p>
  
  <p>So I decided to explore using VBA to warn or open as read only if a file is already open by another user and I have tried to no avail using similar posts to test if the file is open.</p>
  
  <p>I have gotten to the point that it recognises that the current person opening the file, has the file open, which is pretty obvious. But get no further for it to recognise that another user already has the same file open.</p>
  
  <p>Am I chasing a unicorn? Is this perhaps only controllable by Filr setup / settings? Or does anyone have any magical insight to help?</p>
  
  <p>I hope I have posted my problem appropriately :) </p>
  
  <p>Here is my code, so it detects me as 1 user, but when my colleague opens the file after me it still only detects the user count as 1 (not 2 for both of us):</p>
  
  <pre><code>Sub Workbook_Open()
  
  Users = ActiveWorkbook.UserStatus
  
  If UBound(Users) = 1 Then
  MsgBox "File not in use"
  Else
  MsgBox "File already open"
  End If
  
  End Sub
  </code></pre>