Information générale
Catégorie:
COM/DCOM et OLE Automation
Titre:
Server Execution Failed
I am experiencing a problem with automating excel workbooks. I have a table that I loop through. While looping through the table my program opens an closes an excel worksheet as a template. I create a object for excel, open the sheet, place my data and then do a save as. Once the document is saved then I close the workbook and release excel that was open. I then go to the next record in my table, create the object, open the template and then populate it again. After about 30 times I recevieve the message server execution failed. I have also tried moving my create objext out side of the loop and then after about 30 x's my system is out of memory when running my program. When both crashes occur I need to re boot my computer. Does anyone have any suggestions?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement