Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I have very strange problem with excel process. (C#, Win 2k, Office 2002) I can open application process: m_objExcel = new Application(); Later i'm working with this, write some data from sql2000 to cells and try to close excel. Everything seems to be ok but process doesn't end. What's interesting if i have for exeample small quantity of data (single table) process end. But if i have more tables - it doesn't. Are there any timeouts or any tricks to do it? m_objBook.SaveAs(filePath, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, XlSaveAsAccessMode.xlNoChange, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt); m_objBook.Close(false, m_objOpt, m_objOpt); m_objExcel.Quit(); System.Runtime.InteropServices.Marshal.ReleaseComO bject(m_objSheets); System.Runtime.InteropServices.Marshal.ReleaseComO bject(m_objBook); System.Runtime.InteropServices.Marshal.ReleaseComO bject(m_objBooks); System.Runtime.InteropServices.Marshal.ReleaseComO bject(m_objExcel); //Clean-up m_objFont=null; m_objRange = null; m_objSheet = null; m_objSheets = null; m_objBooks = null; m_objBook = null; m_objExcel = null; GC.Collect(); GC.WaitForPendingFinalizers(); thanks in advance P. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using excel to process QIF file | Excel Discussion (Misc queries) | |||
What process is performed behind excel? | Excel Discussion (Misc queries) | |||
How do I make a process map in Excel? | Charts and Charting in Excel | |||
How to Quit an Excel process? | Excel Programming | |||
to kill a excel process | Excel Programming |