Hey guys,
How would I check to see if a file is already open? I have a workbook that automatically opens another workbook and updates a sheet, saves then closes it. The problem is, if it is already open, it is not giving me the in use dialog, just opens a read-only version and carries through. So how could I check with code to see if it is open?
Thanks ahead of time!