1. Bug and Limitation
1-1. [Excel X for Mac] If active sheet does not exist and if you show the dialog and find , the progress is not shown.
Detail:
In this specification , the progress is shown in the Status bar. If Windows , there is the status bar in the lower side of Excel Application Window.
But if Mac , there is the status bar in the lower side of the active window.
Therefore, if Mac and if active window (active sheet) does not exist , the progress is not shown.
Correction schedule: None.
1-2. When you show the result place and if it is in hidden sheet , the place can not be shown.
Detail: The previous sheet is activated.
Correction schedule: None.
1-3. When you show the result place and the place type is cell comment and if it is hidden, the place can not be shown.
Detail: Sorry , an error is occured.
Correction schedule:None.
1-4. Chart sheets is not range of the finding.
Detail: This is a specification.
Correction schedule:None.
1-5. [Excel 97] If you cancel the find , there is a case that an error is occured when file closing.
Detail: The cause is uncertain. Please close the file.
Correction schedule:None.
1-6. If you cancel the find , the status bar is not put back.
Detail: Because if you cancel , the process that the status bar is not put back does not do.
If you want to put back , please input "Application.StatusBar = False" and push the [Enter] key in the immediate window in VBE (Visual Basic Editor).
Correction schedule:None.
1-7. When you find , if target excel file is opend and edited , the editing content is found.
Detail: This is a specification.
1-8. There is a case that it is made to wait from clicking [Find] button to showing the progress in the statuts bar.
And there is a case that it is made to wait even if the progress rate is 100%
Detail: This is a specification bug. Sorry.
Because before the progress is shown , the process checking target files is done.
Therefore , if there is a lot of files ( a lot of subfolder ) , it takes time.
Because the progress rage is 100% means ending of the find , but the outputing result is not done.
Therefore , if there is a log of match place and log , it takes time.
Correction schedule: It corrects it when there is free time.
1-9. If you find in Mac and send the result to Windows , you can not show (jump) the result place. The opposite is also.
Detail: It is because the delimiter of path is different in Mac and Windows.
1-10. There is a bug about grouped autoshape.
[Excel X for Mac] You can not show (jump) the place. ( A runtime error (Number=70) is occured. )
[Excel 97] You can not show (jump) the place. ( A runtime error (Number=1004) is occured. )
[Excel 2000] It is the same as Excel 97.
[Excel 2003] The text in the grouped autoshape is not found.
Note. I confirmed that it can found in Excel 97 , 2000 and Excel X for Mac.
If you find in excluding Excel 2003 and you open result excel file in Excel 2003 , this trouble is not occured.
Detail: I think the bug of the Excel.
1-11. There is a case that when you click the [Browse...] button, automation error is occured.
I confirmed the Excel 2000 only (OS is Windows 98 SE) .
If the target folder is "" , you click [Browse...] , I think that this trouble is occured and Excel Application is abended.
In this case , please input the [target folder] text box. Please don't use [Browse...] button.
1-12. There is a case that the target files is shown in finding
I confirmed the Excel 2003. When file is opened , There is a case that "Application.ScreenUpdating = True".
(Therefore , in the macro of this add-in , after opening file , "Application.ScreenUpdating = False" is done.)
If window is shown , the find does not stopped.
1-13. [Excel X for Mac] The [target folder] text box can not be copyed and pasted.
Even if you push the [Command] + [C] key , it is not copyed.
Even if you push the [Command] + [V] key , it is not pasted.
Please use the [Control] key instead of the [Command] key.