1. Ability
2. Inability
3. Todo
- Finding the text in Excel books under the folder that you select.
The finding target is the file name (book name) , sheet name, cell formula , cell comment and autoshape.
Note.
But the sheet name and autoshape in chart sheets does not found.
The excel book name must end by ". xls". If you use Mac , please pay attention.
If you use Excel 2003 (Windows Edition) , there is a limitation. If autoshapes are grouped , those are not found.
- Showing the result (The result is saved in excel book).
- Showing the result place.
Note.
There is a limitation.
- Showing the progress in the finding and cancel.
Note.
There is a limitation.
- Finding in the documents of Office product other than Excel ( Word , PowerPoint and so on).
- Saving the find condition , and load it.
- Finding the Excel VBA source code.
- Finding in the chart sheet.
- Setting whether the sheet that is hidden is found or not.
- Setting whether the find is executed on the back ground or not.
Note.
In this version, when finding , you can not use the Excel. ( Because Application.ScreenUpdating is False. )
- Setting the finding condition that "Match Case" , "Use Pattern Matching" and "Use Regular Expression".
Note.
In this version, "Match Case" = False , "Use Pattern Matching" = True and "Use Regular Expression" = False.
Sorry , you can not change.
Especially, it is not.