How to check a pathname?
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 !!
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1