Checking valid filepaths

[paulo33]

I have some code in VBA that looks for a file, and then opens it.

Does anybody know of a way to check if the file exists/filepath is valid, before trying to open the file, so as to not produce an error?

thanks

 

[rmikesmith]

paulo33,

This function is from John Walkenbach's book "Power Programming With VBA":

Private Function FileExists(fname) as Boolean
Dim x as String

  x = Dir(fname)
  If x <> &quot;&quot; Then
    FileExists = True
  Else
    FileExists = False
  End If
End Function

HTH
Mike

 

[alrandal]

Paulo I could use some help with the code that goes out and finds the folder, I also have a database that I need the onClick procedure to find a folder, I need some example code. If you could help I would appreciate it.