Need to know who has excel file locked

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sala@datacom.co.nz - 21 Mar 2006 22:28 GMT

Hey there peoples ,

Need help. I know if you click on a excel spreadsheet and it has been
locked for editing by someone else a dialog box displays showing who
has it locked. I have a access application where I open a excel file
using VB. Is there a way to capture who has the excel file locked using
VB . In fact retreiving the same information that displays in the "File
locked for editing" that excel displays

Thanks
Sala

Reply to this Message

Gary Keramidas - 21 Mar 2006 22:34 GMT

if you open the file as read only, you shouldn't see that message. unless you
have some other reason for wanting to know.

something like this:

Workbooks.Open Filename:=fpath & fname, _
ReadOnly:=True, UpdateLinks:=3

Signature

Gary

> Hey there peoples ,
>
[quoted text clipped - 7 lines]
> Thanks
> Sala

Reply to this Message