Check file existis on server dir

Topic

New Reply

I check the file existis in local with a simple script for example if the file is in c:my_dirmy:file.txt
But if the file is in \server_dirmy_file.txt the same code not work, why?
have a tips.?

Reply | Quote

Replies

Sal

Try this 2 part function

Code:

Function FileExist(fname) As Boolean
	 If Dir(fname)  "" Then _
 	 FileExist = True _
 	Else FileExist = False
End Function
'------------------------------------------------------------------------------------
'The VBA code that uses the above function is as follows:
Sub FindFile()

strPath = "\supportAllxmlcode.xml"
 	FileStatus = FileExist(strPath)
 	If FileStatus  True Then MsgBox "Does Not Exist"

End Sub

Reply | Quote