S
Seth
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
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