thanks, I think I'm going to try to move all the excel code into a completely seperate exe and then call it with a name of a temporary table, that should avoid ever crashing the main program and hopefully with it starting it up fresh each time will not crash from memory leaks.

it's worth a go.