newshound12
Active Member
- Joined
- Feb 19, 2003
- Messages
- 339
| Need VBA to find specific word ( Example: Time) in multiple worksheets that are in multiple folders which all are in one folder (Example: 2023). |
-
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.
Find word in multiple worksheets
- Thread starter newshound12
- Start date
then what?
Is it every file in the folders in several folders? Are they dynamic or always the same folders?
What do you do when you find the word (Example: Time) Will there be more than one instance of this in each worksheet or once it's found in 1 sheet, you can stop with that file.
You really need more information with a much higher level of detail in the body before anyone would be able to help you.
Is it every file in the folders in several folders? Are they dynamic or always the same folders?
What do you do when you find the word (Example: Time) Will there be more than one instance of this in each worksheet or once it's found in 1 sheet, you can stop with that file.
You really need more information with a much higher level of detail in the body before anyone would be able to help you.
Upvote
0
newshound12
Active Member
- Joined
- Feb 19, 2003
- Messages
- 339
I want to find the latest worksheet the word is found and stop. There are 52 folders in 1 folder. There are multiple worksheets in each of the 52 folders.
Upvote
0
It sounds like you wanting a VBA to do exactly what a File search function already does.
If you put the word in there it will search the folder and subfolders and tell you which file contains that text, or am I missing something?
If you put the word in there it will search the folder and subfolders and tell you which file contains that text, or am I missing something?
Upvote
0
