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