I have a cell which contains the pathname and filename of a file (eg c:\temp\test.doc), how can I check that this pathname/filename is correct using VBA? The file could be of any type (Word, Excel, txt etc)

Basically I have a macro that will attach this file to an email, but I want to check the user has inputted the correct path & file before the email is created (otherwise an error is created).

Or an alternative is, is there a way to bring up the window browser, the user can then navigate to the required file and then VBA puts that value into the cell.

This second option would be more user friendly, if possible.

I have limited VBA knowledge, good job I'm good at cutting & pasting !!