Auto filter to all csv file in a folder.

  • Thread starter Thread starter shiro
  • Start date Start date
S

shiro

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
 
CSV files are text that can be searched with Windows Explorer Search. go to
the START button on windows and right click. Then select Explore.

Find the Folder with the files on the left half of the window. Then right
click the Folder and select Search.

1) Put in filename box *.CSV
2) Put the record you are looking for in the Word or Phase box.
 
Back
Top