check if file is already open vba code example

Example: vba check if file exists

Public Function IsFile(s)
    IsFile = CreateObject("Scripting.FileSystemObject").FileExists(s)
End Function