Hi Ken and MD, I've been playing around a bit with the index code. But if I understand correctly, should I put it in my workbooks from now on? We have about 5000 files, containing two sheets, stored. I can't search in them. Maybe I'm wrong.

I'd rather use the following idea.....
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.

I realy want to stick to Ken's setup because apart from the IT pc problem it works fine.


Thanks and regards.