Hi Excel Specialist's:

I would need to run the macro to search the multiple csv files(files are stored in share folder, it may have more than 1000 files)depends the search criteria.
E:g
req1:
start date and End Date would be must or all
we need to search the files with in given date range or all write the data into another result file

req2:
start date and End Date would be must or all
also user may select Userid then we need to serch the files with in the date range and find the selected user data only copied into another file.

req:3
start date and End Date would be must or all
aslo user may select the appid along with the date range we need to search the data and copy same into another file.

Please find attached sample file name and data.
FileName
2013-05-13_ABC1
2013-05-13_ABC


Data:

SERVICE DATE USER APPLICATION TIMEOFREQUEST ELAPSEDTIME REQUESTXML
Customer 09/05/2013 User aaplsc 07-05-2013T09:15:13 823 <?xml version=""1.0"" encoding=""UTF-
Details
Service
8""?><S:Envelopexmlns:S=""http://schemas.xmlsoap.org
/soap/envelope/"">soap:Header
xmlns:soap=""http://schemas.xmlsoap.org
/soap/envelope/"">"










Thanks In advance.