Function to check if workbook is open anywhere on the network.
Returns a boolean value.
Author: michael@excelexperts.co.uk
Function IsWorkBookOpenOnNetwork(FullPathAndFileName As String) Dim ff As Long Dim ErrNo As Long On Error Resume Next ff = FreeFile() Open FullPathAndFileName For Input Lock Read As #ff Close ff ErrNo = Err On Error GoTo 0 Select Case ErrNo Case 0: IsWorkBookOpenOnNetwork = False Case 70: IsWorkBookOpenOnNetwork = True Case Else: Error ErrNo End Select End Function