View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 699
Default 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