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

--


Gary


wrote in message
ups.com...
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