locked
Who has workbook open in network RRS feed

  • Question

  • Hello!
    I'd like to determine the username tho has open current workbook at network.
    I found some exapmples that using binary file reading and api's.
    http://www.xcelfiles.com/IsFileOpen.html

    But they did't work for 2007 and later version of excel workbooks!
    http://www.ozgrid.com/forum/showthread.php?t=16548

    In this solution i must place code in every workbook that will be checked.
    The problem is that i don't want to do this because the are many book's that must be checked.
    So, may be somebody know another result that can help me?

    Friday, March 30, 2012 4:18 PM

All replies

  • I use a tool called Unlocker (free).  You right click on a file and click Unlocker and it provides a list of processes that has the file locked.

    http://www.emptyloop.com/unlocker/

    It has a command line interface so you could use that to call it from VBA.  I have never used it.

    Monday, April 2, 2012 12:43 PM
  • It's better something than nothing. Thank you for your reply. But i want to find more independent solution.
    Tuesday, April 3, 2012 11:41 AM