I create a Visual Basic program who reads and writes within an Excel file.
The Visual program instances the Excel Object.
I use Excel to manage the data and the VB program to calculate and to write the result within the Excel file.
The calculation is mathematical and use an Access file to load some data need for the calculation.
My problem is:
When my Excel file is big (Over 500 lines of input) and I make calculation. The Excel file lost the connection with Visual program. I not receive message error. When I use CTRL ALT DEL I see that the Excel object is not respond. When I terminate the Excel my VB program stop because the Excel file is not available. Note for a specific Excel file, the VB program lost the connection with the Excel file at the same row and col.
If I restart my program and I begin the reading of the Excel file at the line where the program has stopping the VB program make calculation without problem. I make the test to start the reading 5 line before the problem appears and the VB program terminate normally.
Do you know this type of problem and the manner to resolve them.
Thank,
