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...
OK.
Somewhere in my original question I noted that one control was Green even though I was setting its Backcolor to Red. The issue here was that the...
Maybe all this is needed when you use your Excel DB from phone, but generally:
Never put same kind of information on separate sheets; I am emulating...