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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Monitor and set an alert for Invalid file names

Status
Not open for further replies.

padhu1989

Technical User
Aug 4, 2015
1
0
0
US
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.
 
... and what have you done so far ? Which subtask makes you the trouble ?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top