Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Device I/O Error ?
I have Excel 2002. My workbook has developed a Device I/O Error. The
message pops up at the finish of every macro that is run, but only if the VBA editor is open. Functions can run without causing the error. I have done a google search on this group and I find people asking this question, but it never gets answered. This workbook is 3 MB with 42 sheets and hundreds of macros. It has 10 forms and does call an ActiveX server. But all of this has been in use for a while. This spreadsheet is a simply a combining of two spreadsheets. I have shut down and restarted Excel. No good. I opened the workbook with repair. No help. A substantial amount of work is at stake. Don <donwiss at panix.com. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Device I/O Error ?
Hi
just two guesses: - You may have installed Google Desktop Search recently? (though I doubt this is the cause for this error) - your file simply has become corrupt. If this is the only file which has this error you may copy everything to a new fresh workbook -- Regards Frank Kabel Frankfurt, Germany "Don Wiss" schrieb im Newsbeitrag ... I have Excel 2002. My workbook has developed a Device I/O Error. The message pops up at the finish of every macro that is run, but only if the VBA editor is open. Functions can run without causing the error. I have done a google search on this group and I find people asking this question, but it never gets answered. This workbook is 3 MB with 42 sheets and hundreds of macros. It has 10 forms and does call an ActiveX server. But all of this has been in use for a while. This spreadsheet is a simply a combining of two spreadsheets. I have shut down and restarted Excel. No good. I opened the workbook with repair. No help. A substantial amount of work is at stake. Don <donwiss at panix.com. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Device I/O Error ?
On Fri, 31 Dec 2004, Frank Kabel wrote:
Don Wiss schrieb: I have Excel 2002. My workbook has developed a Device I/O Error. The message pops up at the finish of every macro that is run, but only if the VBA editor is open. Functions can run without causing the error. I have done a google search on this group and I find people asking this question, but it never gets answered. This workbook is 3 MB with 42 sheets and hundreds of macros. It has 10 forms and does call an ActiveX server. But all of this has been in use for a while. This spreadsheet is a simply a combining of two spreadsheets. just two guesses: - You may have installed Google Desktop Search recently? (though I doubt this is the cause for this error) Nope. - your file simply has become corrupt. If this is the only file which has this error you may copy everything to a new fresh workbook That was the other thing that came up in my search. Something about copying sheets and combining sheets causing this problem. That I have been doing. I just checked. It is only this workbook. Since all 42 sheets are heavily linked to each other I can hope, that moving all to a new workbook in one move will preserve the links. I don't know about copying sheets to a new workbook. All I know is to have both workbooks in view and to drag worksheets to the other. Then user forms and modules can be copied by dragging them. Wait. It went away! I guess while I was sleeping it fixed itself! One thing I did upon awakening was notice that I had several instances of the ActiveX server running. I closed them. I gather that was the cause of my problem. Don <donwiss at panix.com. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Device I/O Error | Excel Discussion (Misc queries) | |||
Device I/O Error | Excel Discussion (Misc queries) | |||
Device I/O Error | Excel Programming | |||
Device I/O Error | Excel Programming | |||
Device I/O Error | Excel Programming |