MACRO FOR READING MANY FILES
 

Hi,

I'm wondering if this can be done:

I have about a 100 files which are identical in format but have data for
different dates...

Is there a way to write a macro that will open and search each of the those
100 files, and copy rows which contain "X" or "Y" in Column Q into a new
spreadsheet?

Would appreciate any help.

Thank you,

H

MACRO FOR READING MANY FILES
 

Hi

You can find examples here
http://www.rondebruin.nl/copy3.htm

You can filter on the Q column then and copy the visible data
If you need more help post back



--
Regards Ron de Bruin
http://www.rondebruin.nl


"hfazal" wrote in message ...
Hi,

I'm wondering if this can be done:

I have about a 100 files which are identical in format but have data for
different dates...

Is there a way to write a macro that will open and search each of the those
100 files, and copy rows which contain "X" or "Y" in Column Q into a new
spreadsheet?

Would appreciate any help.

Thank you,

H

MACRO FOR READING MANY FILES
 

is there any file requirements? when I try my file on the ado test I'm
getting an error...

the file, name, sheet name or range is invalid of: F:\....

Thanks
Hussein

"Ron de Bruin" wrote:

Hi

You can find examples here
http://www.rondebruin.nl/copy3.htm

You can filter on the Q column then and copy the visible data
If you need more help post back



--
Regards Ron de Bruin
http://www.rondebruin.nl


"hfazal" wrote in message ...
Hi,

I'm wondering if this can be done:

I have about a 100 files which are identical in format but have data for
different dates...

Is there a way to write a macro that will open and search each of the those
100 files, and copy rows which contain "X" or "Y" in Column Q into a new
spreadsheet?

Would appreciate any help.

Thank you,

H

MACRO FOR READING MANY FILES
 

If your workbook have a password to open ADO is not working
Use the other examples on my site that open the files (read the Tips for the workbook.open)

--
Regards Ron de Bruin
http://www.rondebruin.nl


"hfazal" wrote in message ...
is there any file requirements? when I try my file on the ado test I'm
getting an error...

the file, name, sheet name or range is invalid of: F:\....

Thanks
Hussein

"Ron de Bruin" wrote:

Hi

You can find examples here
http://www.rondebruin.nl/copy3.htm

You can filter on the Q column then and copy the visible data
If you need more help post back



--
Regards Ron de Bruin
http://www.rondebruin.nl


"hfazal" wrote in message ...
Hi,

I'm wondering if this can be done:

I have about a 100 files which are identical in format but have data for
different dates...

Is there a way to write a macro that will open and search each of the those
100 files, and copy rows which contain "X" or "Y" in Column Q into a new
spreadsheet?

Would appreciate any help.

Thank you,

H

MACRO FOR READING MANY FILES
 

Dear fazal

in the below link you can get how to open all the sheets in a given
folder.
http://www.ozgrid.com/forum/showthread.php?t=21322

i guess this will be solution to your first step of the problem.

Regards
Raza


--
RAZA
------------------------------------------------------------------------
RAZA's Profile: http://www.excelforum.com/member.php...o&userid=34186
View this thread: http://www.excelforum.com/showthread...hreadid=539270