ShakDiesel
New Member
- Joined
- Aug 8, 2013
- Messages
- 2
I have a vba macro established that processes evaluation data stored across multiple worksheets (one per evaluation) in an external workbook. The macro reads information from the evaluation sheet, makes a copy of the appropriate template worksheet in the active/internal workbook, renames the copied template sheet with the evaluation name, and continues to process the data. All works well the first time through.
The problem arises when new evaluations are added from a different external workbook. If all the evaluations are new, everything works well. If one of the evaluations matches a sheet in the active/internal workbook, the macro gives the user the choice of keeping the old information, or replacing it with the new evaluation data. If they keep the old information, the macro skips to the next eval and all is fine. If they choose to replace, the macro deletes the old worksheet in the active/internal workbook, and processes the evaluation in the external workbook with the same code as every other new evaluation.
As mentioned, everything works fine except this "replace" routine which leads to a "corrupted file" message when the workbook is saved (regardless of the save method). The only difference in the process is the worksheet.delete command. I'm not sure why this would be. The only thing I can point toward is that the "replace" method deletes one worksheet, but then creates a new worksheet and gives it the same name as the deleted worksheet. However, I don't know why that would matter. Any ideas?
The problem arises when new evaluations are added from a different external workbook. If all the evaluations are new, everything works well. If one of the evaluations matches a sheet in the active/internal workbook, the macro gives the user the choice of keeping the old information, or replacing it with the new evaluation data. If they keep the old information, the macro skips to the next eval and all is fine. If they choose to replace, the macro deletes the old worksheet in the active/internal workbook, and processes the evaluation in the external workbook with the same code as every other new evaluation.
As mentioned, everything works fine except this "replace" routine which leads to a "corrupted file" message when the workbook is saved (regardless of the save method). The only difference in the process is the worksheet.delete command. I'm not sure why this would be. The only thing I can point toward is that the "replace" method deletes one worksheet, but then creates a new worksheet and gives it the same name as the deleted worksheet. However, I don't know why that would matter. Any ideas?
