I want to monitor the particular Folder where people are placing the excel sheets for some activities.
I want to make sure that people should take care of the below rules before placing the excel sheets.
1. The excel sheet should be in xls format (Excel 97-2003 Workboomk Format)
2. The excel file name should not contain any space
3. The length of the filename should not exceed 15 characters.
I want to set a email alert to me if the users placed a excel sheet without following the above 3 rules.
I need a VB script to monitor the folder. Kindly help me on this.
I want to make sure that people should take care of the below rules before placing the excel sheets.
1. The excel sheet should be in xls format (Excel 97-2003 Workboomk Format)
2. The excel file name should not contain any space
3. The length of the filename should not exceed 15 characters.
I want to set a email alert to me if the users placed a excel sheet without following the above 3 rules.
I need a VB script to monitor the folder. Kindly help me on this.