Is there a way to tell if a workbook is open on a network drive? If someone
has this workbook open, there name will be in sheet1 range A1.

Is there a statement that can tell me 1. if the workbook is open and 2. the
name of the person who has it open (range A1)?

i have played with referring to it as such, but am not sure of the rest of
the code i should use.

workbooks("\\servername\folder name\file name.xls")