Search across multiple workbooks

E

Ed K

Is there a way to "Find" or search for a string of characters contained not
just in a single workbook but across multiple workbooks?

As an aside, I've written a macro that can read multiple closed files and
extract data from any cell. Not sure if this is the route I eventually must
take.

Ed
 
D

Dave Peterson

Nothing built into excel.

But you could write a macro that would do the Find against all the open
workbooks (and worksheets within those workbooks???)--or even open all the files
in a folder to look through them.
 
L

Lori

Nothing built into excel.

But you could try this [deprecated] function from the VBA immediate window:
(or assign it to a toolbar button.)

application.Dialogs(xlDialogWorkgroup).Show

Press OK to select all workbooks then use Crtl+F and Find ALL.

*DON'T use Find Next if the search string is not in the current workbook, it
can cause instability in XL2003*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search for a text string across multiple workbooks 3
Searching Multiple Workbooks 2
Look up across multiple sheets 1
Multiple Workbooks using same macro 4
Combining Multiple Workbooks 1
Multiple workbooks to one worksheet 3
Sharing workbooks limitations - Merged Cells 12
Creating multiple workbooks from summary workbook 2

Top