General information
Category:
COM/DCOM and OLE Automation
Title:
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?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only