Device I/O Error
 

Using Excel 2007. I frequently get a Visual Basic Error "Device I/O Error"
when opening an application that I designed. Most of the designs were
originated in Excel 2003. Sometimes the error box appears upon opening the
application. When I click OK, and click on another cell in the same
worksheet, the error re-appears. This may continue 4 or 5 times and then it
is fine. Almost every time this occurs, Excel crashes within 5 or 10 minutes.
After I reload the application, it is fine. I believe all the errors occur on
apps that have a Workbook_Open event or Worksheet_Change event. However, it
is not consistent, happening 50% of the time or less.

Any advice would be appreciated since it is a major nuisance.

Thanks in advance.

Sam

Device I/O Error
 

Post your code. If you think the problem is related to Workbook_Open event
and Worksheet_Change, post just those for starters.

Without knowing what your code does, it is unlikely that anyone will be
able to help you troubleshoot. Are you doing database calls? Listening on a
serial port? Trying to connect to a network drive? Connecting to a printer or
driver? Grabbing web pages?

"Sam" wrote:

Using Excel 2007. I frequently get a Visual Basic Error "Device I/O Error"
when opening an application that I designed. Most of the designs were
originated in Excel 2003. Sometimes the error box appears upon opening the
application. When I click OK, and click on another cell in the same
worksheet, the error re-appears. This may continue 4 or 5 times and then it
is fine. Almost every time this occurs, Excel crashes within 5 or 10 minutes.
After I reload the application, it is fine. I believe all the errors occur on
apps that have a Workbook_Open event or Worksheet_Change event. However, it
is not consistent, happening 50% of the time or less.

Any advice would be appreciated since it is a major nuisance.

Thanks in advance.

Sam