Check Which User Has File/Workbook Open

gollem · Jul 28th 2004

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.
workbooks.open ....
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 ....

Thanks

Khautekier · Oct 23rd 2006

Re: Check which user has excel-file open

Hello,

Today i was searching the net for the same problem.
Your post is already 2 years old. But it can help other people as well.

i found a solution at the following hyperlink
http://www.xcelfiles.com/IsFileOpen.html#anchor_37

Best regard.
A learning Belgium guy.

Anonymous · Oct 23rd 2006

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.)

Check Which User Has File/Workbook Open

Participate now!

Share