Need to know who has excel file locked

[sala]

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

 

[Gary Keramidas]

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