Click on the field you want to validate. On the menu bar go to 'Data' and then 'Validation'. There are a few tabs within 'Validation' where you can set the requirements along with input message and error alert.
Use the FileSystemObject Class. You will want to create a folder variable as well and then loop through the files within your chosen folder. Have it copy the names of the file into a table - you can use the Left() or Right() to obtain your specific file name.
Here's part of an app I created...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.