Hey,

I am new to this forum and would really appreaciate some assistance with what I'm trying to do.

I am trying to create a VB 6.0 program that automatically reads a .csv file created in a specific directory (say c:\), open it and then copy a new entry in a new row.

More detail:

There is a new excel .csv file created each day (generated by a test procedure) that contains test results. Each day a test is performed a new file is created...the first test will take on the first row in the excel workbook. Each consecutive test afterwards takes on the second and the third and so on. The program that does this is some alien program. [New file for each test day and new row for each single test]. No test in a day, no file created.

?Is it possible to create a program that automatically reads a new file created in a directory as well as any new entry in that file (excel file) and then make a copy of it (...then paste it to another excel file)?

Your help will be really appreciated...thanks