Check for file in folder then execute code

[jeffwest1]

I am sure that it is listed here somewhere but I cannot find it.

I would like to have a program running in the background that will be checking the contents of a folder, once a file exists with a certain name, the following will happen.

A) Create text file with names and update dates of all files in folder (approx 200)
B) Run some excel VBA code to open,update and close a series of spreadsheets (already written code for this)
C) Create new text file with names and update dates of all files in folder (to look for non updated files)

What i could do with is a pointer to some code for VB that will help me do this.

I used VB sometime ago, so not a total novice, but am struggling with syntax and could really do with the help.

--------------------------------
Luke: But tell me why I can't...
Yoda: No, no, there is no why. Nothing more will I teach you today. Clear your mind of questions.

 

[HughLerwill]

The following may be of interest;
thread222-1389957
thread222-719707