I am running a VBA macro application in Microsoft Excel 97 under Windows XP -Service Pack 1 to,
1.Open an Excel work book .
2.Update a value in a cell
3.Save and close the file.
I need to repeat the steps 1,2,3 for 1,00,000 times. But after executing the process around 32,000 times the Excel application crashes.The whole OS hangs. And a message box appears As
" Run time error -2147467259 (80004005) ", method 'open' of object workbook's failed.
I am facing this problem since last two weeks, If any body have the solution please comment it .
Thanks
Arunraj.N
1.Open an Excel work book .
2.Update a value in a cell
3.Save and close the file.
I need to repeat the steps 1,2,3 for 1,00,000 times. But after executing the process around 32,000 times the Excel application crashes.The whole OS hangs. And a message box appears As
" Run time error -2147467259 (80004005) ", method 'open' of object workbook's failed.
I am facing this problem since last two weeks, If any body have the solution please comment it .
Thanks
Arunraj.N