|Hi, thanks for your responses, that was very much appreciated. |
- AlteK, yes I agree, the issue may be an Excel update issue. However, I have tried removing the updates (no success), re-installing latest updates (no success) repairing Microsoft Office 2010 (no success) and the next step would be to re-install Microsoft Office 2010.
-Derby, yes that's normal, if the file is ran twice within the same hour, it will prompt to save over the existing files created. The weird thing is, the computer having the problem is on a XP SP3 OS. I've tried on a PC with Windows 7 OS, as well as another PC running XP SP3, which works fine. This leads me to to think that the problem is either an Office update, Windows update or Virus issue. The process still works if I click end on the run-time error, but just an inconvenience to have to keep clicking end. If you all know of a way to stop the run-time error 13 from popping up, that would help as well. Thanks.