Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search across multiple workbooks
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search across multiple workbooks
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. Ed K wrote: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search across multiple workbooks
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* |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
search text in other workbooks | Excel Worksheet Functions | |||
search and link workbooks | Excel Discussion (Misc queries) | |||
Updating Workbooks from multiple links Workbooks | Excel Worksheet Functions | |||
How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
search through workbooks | Excel Worksheet Functions |