Check Which User Has File/Workbook Open

  • Hello,

    I have a program that opens an excel-workbook, I first check whether the file is opened by another user(open for read-write). This works fine, but I'd like to know which user has the file open with VBa code.

    ex. ....
    if open
    then msgbox "Book opened by user"
    end if

    So it's the same as you open an excel(with your windows explorer) on a network and you get the message that the file is already opened by the user ....


  • Re: Check which user has excel-file open

    Hi, Khautekier, and Welcome to OzGrid

    Thank you for sharing this link. There is so much to learn in Excel and every bit of shared knowledge helps. (That's what Oz is all about.)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!