I want to create a macro that allows me to search for particular string in a worksheet of a closed workbook. The idea is to have a textbox on a form in which I can type in a string, "something". The macro would then try to find such a string in sheet1, for example, in a closed workbook. If this string is found, it will report the name of the workbook where this string is located. I will have this routine in a loop to read any number of workbooks to perform this search routine. How to accomplish this? I don't even know how to start.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Reading a closed workbook
- Thread starter dave8
- Start date
-
- Tags
- read closed workbook
Jerry Sullivan
MrExcel MVP
- Joined
- Mar 18, 2010
- Messages
- 8,787
Dave,
I'm not aware of a way to do what you're describing that wouldn't be very slow relative to other file search options.
Excel appears to "read" closed workbooks that are referenced by worksheet formulas or data connections, but that's only because the data has been read into Excel upon opening the workbook and updating the links.
If you wanted to search a folder with a large number of Excel files you could have a macro open each one and search for the string, but this would be very slow compared to Search Apps like Windows Search Desktop or Google Add-Ins.
I'm not aware of a way to do what you're describing that wouldn't be very slow relative to other file search options.
Excel appears to "read" closed workbooks that are referenced by worksheet formulas or data connections, but that's only because the data has been read into Excel upon opening the workbook and updating the links.
If you wanted to search a folder with a large number of Excel files you could have a macro open each one and search for the string, but this would be very slow compared to Search Apps like Windows Search Desktop or Google Add-Ins.
Upvote
0
Upvote
0
Similar threads
- Question
- Question
