I'm currently developing some software that accepts a list of words from a file and then searches all matching excel files found in a given folder. The issue i've run into is that searching a large spreadsheet (A1-N64000) seems to progressively become slower. This particular problem can be duplicated by opening this large spreadsheet and searching for a term that is found on the 64000th row. When clicking "Find Next" the box that has the current cell updates quickly and then starts updating every 100 rows or so, eventually diminishing to about 20 rows. I've tried setting all excel properties (screen updating, calculation, alerts, hiding, etc...) but none of them seem to work. Does anyone have an efficient method of searching an excel workbook programmatically? I'm using XP with Office 2003.
Thanks in advance.