Hi Ken, I hope you don't think by adding this in your reply
Originally Posted by Airborne
Windows search doesn't open the files but just shows the files in the search window containing the hits. You can open them yourself. Is it not possible that Ken's routine not opens the files but just shows them in an extra page of my Data.xlt workbook. As you know it contains the "data" and "stock" sheet and I can also add a "search" sheet. The workbook contains Ken's routine and other routines (one to copy/paste the two sheets in a new workbook giving it the name Datadd-mm-yyyy.xls (containing no macro's) storing it in year\etc. We then close the Data workbook again.
That your module doesn't work because it does work and it works great! I have a search engine that works and a status bar that looks cooler than the one WindowsXP shows. I meant that the search engine in WindowsXP doesn't show opening files when you look at the screen. Your module doesn't show opening files either. The only thing is that after te search the sheets with the hits are all showing in the task bar and after WindowsXP search the files with the hits are shown as hyperlinks in the search window. With a lot of files open the last case seems slightly better.

It's not really a problem though. It's more nice to have . I have heaps of other questions about VBA that I can't solve at the moment so how about calling this thread solved so you can help me with my other questions

Regards.