Hi All,
is it possible to apply auto filter to a workbook that is not open?

May be you will ask why do I want to do this.
Here is my situation.
I have a software that outputting records to excel.csv file.And
automatically
save the workbook in a folder named : format(Now ,"yyyy-mm-dd").And
all of the folder are kept in a folder named Result.

This software had been used since a year ago.So there are about 300 folder,
that kept csv file.And in a csv file there are about 400-600 records.

Now I want to be able to retrieve a record and then know which workbook
in which folder which kept the records.Is it possible with vba?

One thing similar,all csv files have similar structure.Is there somebody can
help
me?

Thank's

rgds,

Shiro