search through workbooks

[Martin Wheeler]

xl2003
I have approx 5000 worksheets in about 500 workbooks.
What I want to do is to define a search criteria and then have it look
through all the workbooks and then copy the relevant worksheets to a new
workbook.
Is this possible? Will the workbooks have to open or can I look through
closed ones?
Or will I have to build a database? I had thought of copying every worksheet
to Access, doing the searches and then copying the results back to excel but
this seems rather longwinded.
Any help would be greatly appreciated.
Ta,
Martin

[cscorp]

Martin,

What I have done before is to use a workbook as a program that open each workbook (once at a time), perform the scan, do the actions, and close the workbook before moving to the next one. It runs fast. I am not sure you can do it with the workbooks closed, however I will double check and will get back to you by tomorrow. Let me now if you need the program that perform the scanning.

Regards
Juan Carlos

[Martin Wheeler]

Hi Juan,
Sorry to be so long in getting back to you.
I am interested in your program and would like to know more about it.
Ta,
Martin


"cscorp" <[email protected]> wrote in
message news:[email protected]...
>
> Martin,
>
> What I have done before is to use a workbook as a program that open
> each workbook (once at a time), perform the scan, do the actions, and
> close the workbook before moving to the next one. It runs fast. I am
> not sure you can do it with the workbooks closed, however I will double
> check and will get back to you by tomorrow. Let me now if you need the
> program that perform the scanning.
>
> Regards
> Juan Carlos
>
>
> --
> cscorp
> ------------------------------------------------------------------------
> cscorp's Profile:
> http://www.excelforum.com/member.php...o&userid=24015
> View this thread: http://www.excelforum.com/showthread...hreadid=376983
>