While doing some simple programming using the ADO object
model to query an Excel workbook I keep getting a message
box in the VBE that says "Device I/O Error". The code
executes fine, and I don't get the error unless I am in
the VBE!

It was suggested that this was the result of a workbook
object variable not being set to nothing...however, there
was no workbook object present when the message
appeared. It only occurs when the VBE is active. I use
the "Close" method of the recordset object and set it to
nothing after the query.

Does anyone know what is going on?

Thanks,

Seth