View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] sala@datacom.co.nz is offline
external usenet poster
 
Posts: 1
Default Need to know who has excel file locked

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