Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidate different sheets to different workbooks | Excel Worksheet Functions | |||
FAQ Spreadsheet with search function | Excel Discussion (Misc queries) | |||
Linking Workbooks | Excel Worksheet Functions | |||
Automatic updating worksheet data between different workbooks | Excel Worksheet Functions | |||
Workbooks...I'll try this again... | Excel Discussion (Misc queries) |