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?