vanhunk
04-27-2014, 09:08 AM
Excel 2010 Bug?!
I hope there is someone out there with a solution.
I/O errors,Out of Memory messages and crashing of Excel caused by duplicate VB Projects in VBE.
When opening and working on code in the VBE, the code stays in the the VBE even after the workbook has been closed. When the workbook is opened again, it loads another set of the same code into the VBE and when the macros are activated, I/O errors, out of memory messages and/or crashing of Excel errors are caused.
My programs and code worked perfectly in Excel 2003 and when we changed over to Excel 2010 funny things started happening. I first thought it is my code but soon realised that the code stays in the VBE after the workbook has been closed. Closing and reopening the VBE does not help. Only when I close and restart Excel the code is cleared.
1) Is there a fix or a patch for Excel 2010 to stop this from happening?
2) Are there any workarounds for this problem?
Thank you very much,
vanhunk
I hope there is someone out there with a solution.
I/O errors,Out of Memory messages and crashing of Excel caused by duplicate VB Projects in VBE.
When opening and working on code in the VBE, the code stays in the the VBE even after the workbook has been closed. When the workbook is opened again, it loads another set of the same code into the VBE and when the macros are activated, I/O errors, out of memory messages and/or crashing of Excel errors are caused.
My programs and code worked perfectly in Excel 2003 and when we changed over to Excel 2010 funny things started happening. I first thought it is my code but soon realised that the code stays in the VBE after the workbook has been closed. Closing and reopening the VBE does not help. Only when I close and restart Excel the code is cleared.
1) Is there a fix or a patch for Excel 2010 to stop this from happening?
2) Are there any workarounds for this problem?
Thank you very much,
vanhunk