Is shared workbook open?

[D_N_L]

Hi all,

I have researched this but can't seem to find anything that works for me. I have tinkered.

I have an Excel file (xlsm) on a shared network. Quite simply (ahem!) I want to determine if the file is open (in any guise - read only, etc) from another workbook.

Please Login or Register  to view this content.

Something like that anyway.

[ragulduy]

I'm not sure you would be able to check if a user has a file open in read-only mode. I would guess you can only check if it is locked or not.

You might be able to create a workaround but I'm not sure if it would be worth it... You would have to add code to the workbook open and close events to update a textfile log which contains the state of the workbook but even then you would run into issues if excel crashes or if two users open it as read only (one would close it which would update the text file and the other would still have it open). Perhaps you could use the ontime method to regularly update the text file whilst the excel file is open and have a script change the status of it if it hasn't been accessed for a period of time.

It's all a bit messy though and is unlikely to work well in practice. You can use the method here to check if it is open AND locked:
http://www.mrexcel.com/forum/excel-q...ther-user.html

[D_N_L]

Thanks Rag - i'll try that.