Watch folder program

Working on a program that watching a folder for specific xl files and when a new file hits the folder, I need it to automatically open itself in excel.   No idea where to start.
Who is Participating?
can you brief some more ?

is that program file tracking program that watches file behavior ? like new file auto open in folder ?

if i am right and close to your requirement. you can start thinking by searching(search function)  for excel file in particular folder. compare the created  file date and time with current date and time to open newly hit file in folder.
DJ_ConsultingAuthor Commented:
I created another program that saves csv files from a different machine to a protected network folder.   I have excel set to run a macro automatically that processes this file and emails it to the appropriate people.  

I want to create a vb program that will always run on a certain PC and when it detects a new file written to the network folder, it would open this file in excel with no user interaction.
DJ_ConsultingAuthor Commented:
This is exactly what i needed to get the right direction
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.