Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by shoyle

  1. shoyle

    Adding validations in excel

    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.
  2. shoyle

    How can I import file names into a table?

    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...

Part and Inventory Search

Back
Top