module function question

[Pouncer]

I have this function in my Form1,Form2,Form3 .. a bit of stupid way to do it..

Function File_Exists(strFilePath As String)
    If Dir(strFilePath, vbNormal + vbHidden + vbSystem + vbReadOnly) = "" Then
        File_Exists = False
    Else
        File_Exists = True
    End If
End Function

if i just simply put that in a module exactly how it is, will it work from form1,form2,form ?

i use it like this..

If File_Exists("C:\test.txt) Then... 'etc..

[manavo11]

Yes. To be sure you can declare it as Public Function...

[MartinLiss]

As you have it defined, your function returns a Variant and it would be a tiny bit better if you defined it this way...

Function File_Exists(strFilePath As String) [HL="#FFFF80"]As Boolean[/HL]