Need to know who has excel file locked

  • Thread starter Thread starter sala
  • Start date Start date
S

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
 
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
 
Back
Top