My 10p (I am British :) ) is to try and apply db principles to an Excel workbook. You will not get everything an Access db could give you, but should...
I can't see anything obvious but for sure the problem lies on the Excel side. I'd try putting a break point on rst.close then go to task manager and...