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.

"shiro" wrote:

> 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
>
>
>

Hi shiro

Maybe this (example 4)
You can change it to open csv files instead of xls?

http://www.rondebruin.nl/copy3.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"shiro" <shiro@myname?.com> wrote in message news:(E-Mail Removed)...
> 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
>
>