I am trying to check if a file exists within a network before running addition code to create a new (same name) file. If the file exists if will abort the next step

I am running this from vba code.
Notes 1. the file name has no extension
      2. The path is unc based ie(\\myhost\myfolder\file)

Any Help would be appreciated

Thanks
Darren

Set objFSO = CreateObject("Scripting.FileSystemObject")
    If objFSO.FileExists("\\myhost\myfolder\file") Then
    Exit Sub
Else
        'do something here... do you know how to create a file?
End If


Why no extension?


mmcdonal

thanks for that it worked a treat....... the reason for no extension is that the file is to be interfaced into a unix system.

Thanks again for your time

Cheers
Darren