search through workbooks
 

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

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

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" wrote in
message ...

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