ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Device I/O Error (https://www.excelbanter.com/excel-programming/271073-device-i-o-error.html)

Seth[_3_]

Device I/O Error
 
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


All times are GMT +1. The time now is 01:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com