verifica daca un fisier exista in director cu excel

salut

vreau sa fac  un macro care verifica daca un fisier exista sau nu la o anumita adresa, de ex:
am 1.txt, 2.txt si 3.txt pe desktop si in excel am link catre ele dar linkul se formeaza pe baza celulelor din excel si in excel am linkuri catre 1.txt, 2.txt,3.txt si 4.txt, 5.txt care nu exista la primele 3 vreau sa apara true iar la untimele 2 sa apara false.
Am cautat pe net si am gasit mai multe coduri de vba dar toate imi dau valoarea false.

1.

Function FileExists1(sPath As String)
	FileExists = Dir(sPath) <> ""
End Function

2.

Function FileExists(FilePath As String) As Boolean

	Dim FileName As String

	FileName = Dir(FilePath)

	If FileName <> "" Then FileExists = True _
	Else: FileExists = False
End Function

3.

Sub TestHLinkValidity()
Dim rRng As Range
Dim fsoFSO As Object
Dim strFullPath As String
Dim cCell As Range
Set fsoFSO = CreateObject("Scripting.FileSystemObject")
Set rRng = Selection
For Each cCell In rRng.Cells
	If cCell.Hyperlinks.Count > 0 Then
		strFullPath = ActiveWorkbook.path & "\" & cCell.Hyperlinks(1).Address
		If fsoFSO.FolderExists(strFullPath) = False Then
			cCell.Interior.ColorIndex = 3
		Else
			cCell.Interior.ColorIndex = 0
		End If
   End If
Next cCell
End Sub

4.

Function FileExist707(path As String) As Boolean
	If Dir(path) <> vbNullString Then FileExist = True
End Function

Ce ar trebui sa fac sa sa imi recunoasca linkurile care sunt active?

Multumesc.

Edited by MarianG, 05 May 2017 - 08:35.
tag-uri code

ionita_adrian, on 24 aprilie 2017 - 12:32, said:

VBA e un limbaj atat de simplu...
Verifica sintaxa codului.
Declari functiunea iar aceasta ofera un rezultat.

Function FileExist707(path As String) As Boolean
If Dir(path) <> vbNullString Then FileExist707 = True
End Function

Pentru formatare foloseste Conditional formatting (in tabul Home).

Edited by shobosorin, 24 April 2017 - 14:53.