Hello Everyone,

This is my first Post. So, if I made any mistake just forgive that and post.


Basically, user at my office get so many daily production reports from factories. It consists of Machine name, Efficiency of it, Production and Stopage time. Our planner gets aroun 10 files everyday... So much data. So I wrote a macro that gives the user one file with Factory name, its total Efficiency , Production And Stopage. This solved the Daily Production Report Problem.

But what I want is user will choose From Date and To date and the Daily Production Report which I created from that data will come on some intermediate file and formulate there and then user will get the Monthly production report or rather the Production report for the dates he choose.

What I want user will only see the names of the files which are present in that folder. like
Daily Production Report(1-Jan-2012)
Daily Production Report(2-Jan-2012)
Daily Production Report(3-Jan-2012)
Daily Production Report(4-Jan-2012)
Daily Production Report(5-Jan-2012)
..
..
..
and then he will choose two dates and after pressing a button he will get the report.




So please help me