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 |
Need to know who has excel file locked
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 |
All times are GMT +1. The time now is 12:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com