Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Using the C Excel API, I am attempting to open, read, and close numerous
Excel workbooks. A representative code snippet is below. After opening the same 4 meg file 936 times, get an inexplicable Excel crash. I appear to have exceeded the limits of an Excel memory heap. Any tips on how to test for/prevent a crash, on how to free Excel memory in this case? XLOPER xRes; for ( int i = 1; i <= 1000; i++ ) { // open file read only int res = Excel(xlcOpen, &xRes, 3, TempStr(" workbook.xls"), TempNum(0), TempBool(TRUE) ); xRes.xltype |= xlbitXLFree; Excel( xlFree, 0, 1, (LPXLOPER) &xRes ); // close file Excel(xlcClose, &xRes, 1, (LPXLOPER)TempBool(FALSE)); } |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Opening multiple excel workbooks at once | Excel Discussion (Misc queries) | |||
Opening multiple workbooks in Excel | Excel Discussion (Misc queries) | |||
Opening Excel workbooks | Excel Worksheet Functions | |||
Problems opening excel workbooks | Excel Discussion (Misc queries) | |||
How do I stop IE opening excel workbooks ? | Excel Discussion (Misc queries) |