Usage
About Result
1. About Result Excel Book
2. About [Condition] Sheet
3. About [Result] Sheet
4. About [Log] Sheet
1. About Result Excel Book
When you find , the result Excel Book is saved and shown.
The folder that the book is saved is "The folder this add-In is saved"\Result.
And the name of the book is "yyyymmddhhnnss".xls.
Please delete the book properly , or the books are collected.
The book has a macro. ( The macro is the same as the one of ResultTemplate.xls. )
If you use Windows , before you open the book , please check the Securty setting in Excel ([Tools]-[Macro]-[Security...])
Even if this add-in (searchExcelBook.xla) is not installed , you can open this book and jump the result place.
2. About [Condition] Sheet
The finding condition is outputed.
Figure 3 - [Condition] Sheet
3. About [Result] Sheet
The finding result is outputed.
If you double click the No. , the result place is shown.
Figure 4 - [Result] Sheet
4. About [Log] Sheet
The log is outputed.
Even if an error ( example: file can not be opened ) is occured , this add-in does not inform an error during finding.
Therefore, please check the error log after finding.
Figure 5 - [Log] Sheet