check if another user has an xls file open?
 

I need to be able to check if another user has an excel workbook open (from a network drive) from within another workbook. user 1 has workbook1 open and has a macro to open workbook2, paste some data in, save it and close it, I need to add code to the macro to say if workbook2 is already open...