Find Filename with VBA

[questionguy]

Is it possible to create a vba code that is able to check whether or not a file exists.
Basically, I would have a userform with a textbox where a user is able to type in a filepath with filename.
Upon clicking a button the code would check if if that file exists or not. If not then it would pop a msgbox.
No idea if that's possible. Any suggestion?

[JieJenn]

Try the function below. strDirectoryPath is path of the file.

Please Login or Register  to view this content.

[mike7952]

A google search of vba code to check if file excist will give plenty of codes. Heres just one link

http://www.excelguru.ca/content.php?157

[questionguy]

@JieJenn

Do I create a new module for the function you provided and can I then include that function in my userform button?
I am asking, because I have a userform where a user can enter the directory path and filename, and based on these textboxes I would like to check whether or not the file exists to continue working on the new workbook.

Thanks in Advance

[JieJenn]

You copy and paste into a standard module and you treat it like a function that you normally use on daily basis.

[questionguy]

Alright, what if I want the function to work in a User Form like the one I attached below?

Pretty much I am debugging my userform rightnow and my goal is to show a msgbox when the the filename does not exists. Hopefully my attachment makes more sense...

[mike7952]

Maybe something like this. Im not sure exactly what your trying to do though.

Please Login or Register  to view this content.

[JieJenn]

the code will look like if file does not exist

Please Login or Register  to view this content.

[questionguy]

Thanks guys your are geniuses...!!