Solved: Search engine

[Ken Puls]

Hi Airborne,

Hi, talked to the IT guys. Excel was damaged on three IT pc's. After a repair.....everything worked. A steady screen and a working bar .

Excellent! One issue down, at least!

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.

Hmmm... The problem that I see here is that with the data stored in textboxes, I can't find a way to access the various files without opening them. If you were to throw a Workbook_BeforeSave event in the template (that creates all of your data files) to copy all the textbox info to cells on a separate sheet ("search" as referred to above) I think that we could adapt Joseph Rubin's idea here. Even that would be some work, though, as the methodology for this would be to create a link to a sheet in your main workbook from each cell in the search sheet of every file in the directory. You're still talking about setting up a loop to talk to each file in the directory though. Having never used Mr. Rubin's method before, I can't guarantee that it would even be any faster...

It may be possible to just launch windows search utility right from Excel (I'm not sure what to call to do this though), but does it search textboxes within the file? I'm not sure...

PS: MD, I think that the only lines of code that aren't 2000 compliant are the lines calling .ShowWindowsInTaskbar (That one was definately added in 2003). I think that the rest of the code should be backwards compatible.