Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
closing excel file through code
Hi,
I am using Excel for reporting. For opening excel file I have write code : exlApp = null; exlApp = new ApplicationClass(); //try //{ object missing = System.Reflection.Missing.Value; string path = oString(); excelWorkbook = exlApp.Workbooks.Open(path, missing, 1, missing, Excel.XlTextQualifier.xlTextQualifierNone, missing, missing, missing, true, //COMMA missing, missing, missing, missing ); path = ""; path = (); path = path + @"\" + frmSiteName.siteName + " GenSumm " + DateTime.Now.Day + "_" + DateTime.Now.Month + "_" + DateTime.Now.Year + " " + DateTime.Now.Hour + "." + DateTime.Now.Minute + ".csv"; excelWorkbook.SaveAs(path, missing, missing, missing, missing, missing, XlSaveAsAccessMode.xlNoChange, missing, missing, missing, missing); object pwd = "cgclogic"; excelWorkbook.Unprotect(pwd); Excel.Sheets excelSheets = excelWorkbook.Worksheets; excelWorksheet = (Excel.Worksheet)excelSheets.get_Item("Log Report"); excelWorksheet.Unprotect(pwd); And before that form termination, write code : excelWorkbook.Save(); exlApp.Workbooks.Close(); exlApp.Quit(); exlApp = null; excelWorksheet = null; excelWorkbook = null; This form is opening through MDI. But even after form close 'Windows Task Manager' is showing 'Excel' in process. And after application colse it is removing from task manager. When that file in the reports folder try to open, it is giving error : " This file is already opened . DO you want to reopen the file ?" or " This file is being modified by other user . Open a read-only copy." please tell how to close that file using code. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
closing excel file through code
Only a guess but try changing
exlApp.Quit(); exlApp = null; excelWorksheet = null; excelWorkbook = null; to - excelWorksheet = null; ensure all unsaved wb's are closed, after saving or with close false excelWorkbook = null; exlApp.Quit(); exlApp = null; Regards, Peter T "Namrata" wrote in message ... Hi, I am using Excel for reporting. For opening excel file I have write code : exlApp = null; exlApp = new ApplicationClass(); //try //{ object missing = System.Reflection.Missing.Value; string path = oString(); excelWorkbook = exlApp.Workbooks.Open(path, missing, 1, missing, Excel.XlTextQualifier.xlTextQualifierNone, missing, missing, missing, true, //COMMA missing, missing, missing, missing ); path = ""; path = (); path = path + @"\" + frmSiteName.siteName + " GenSumm " + DateTime.Now.Day + "_" + DateTime.Now.Month + "_" + DateTime.Now.Year + " " + DateTime.Now.Hour + "." + DateTime.Now.Minute + ".csv"; excelWorkbook.SaveAs(path, missing, missing, missing, missing, missing, XlSaveAsAccessMode.xlNoChange, missing, missing, missing, missing); object pwd = "cgclogic"; excelWorkbook.Unprotect(pwd); Excel.Sheets excelSheets = excelWorkbook.Worksheets; excelWorksheet = (Excel.Worksheet)excelSheets.get_Item("Log Report"); excelWorksheet.Unprotect(pwd); And before that form termination, write code : excelWorkbook.Save(); exlApp.Workbooks.Close(); exlApp.Quit(); exlApp = null; excelWorksheet = null; excelWorkbook = null; This form is opening through MDI. But even after form close 'Windows Task Manager' is showing 'Excel' in process. And after application colse it is removing from task manager. When that file in the reports folder try to open, it is giving error : " This file is already opened . DO you want to reopen the file ?" or " This file is being modified by other user . Open a read-only copy." please tell how to close that file using code. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
closing excel file through code
Thanks for reply !
I change the code as: excelWorksheet = null; ensure all unsaved wb's are closed, after saving or with close false excelWorkbook = null; exlApp.Quit(); exlApp = null; But excel file still remains open. "Peter T" wrote: Only a guess but try changing exlApp.Quit(); exlApp = null; excelWorksheet = null; excelWorkbook = null; to - excelWorksheet = null; ensure all unsaved wb's are closed, after saving or with close false excelWorkbook = null; exlApp.Quit(); exlApp = null; Regards, Peter T "Namrata" wrote in message ... Hi, I am using Excel for reporting. For opening excel file I have write code : exlApp = null; exlApp = new ApplicationClass(); //try //{ object missing = System.Reflection.Missing.Value; string path = oString(); excelWorkbook = exlApp.Workbooks.Open(path, missing, 1, missing, Excel.XlTextQualifier.xlTextQualifierNone, missing, missing, missing, true, //COMMA missing, missing, missing, missing ); path = ""; path = (); path = path + @"\" + frmSiteName.siteName + " GenSumm " + DateTime.Now.Day + "_" + DateTime.Now.Month + "_" + DateTime.Now.Year + " " + DateTime.Now.Hour + "." + DateTime.Now.Minute + ".csv"; excelWorkbook.SaveAs(path, missing, missing, missing, missing, missing, XlSaveAsAccessMode.xlNoChange, missing, missing, missing, missing); object pwd = "cgclogic"; excelWorkbook.Unprotect(pwd); Excel.Sheets excelSheets = excelWorkbook.Worksheets; excelWorksheet = (Excel.Worksheet)excelSheets.get_Item("Log Report"); excelWorksheet.Unprotect(pwd); And before that form termination, write code : excelWorkbook.Save(); exlApp.Workbooks.Close(); exlApp.Quit(); exlApp = null; excelWorksheet = null; excelWorkbook = null; This form is opening through MDI. But even after form close 'Windows Task Manager' is showing 'Excel' in process. And after application colse it is removing from task manager. When that file in the reports folder try to open, it is giving error : " This file is already opened . DO you want to reopen the file ?" or " This file is being modified by other user . Open a read-only copy." please tell how to close that file using code. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
closing excel file through code
Are all your object variables released in opposite order to which they were
referenced. Just for testing, make the instance visible exlApp.visible = true close all workbooks and release your objects do not do exlApp.Quit Do you have any workbooks open, if so why, eg, xl is waiting for user to dismiss some message perhaps also check for any hidden workbooks, alt-F11 and look in projects panel in the VBE Manually quit Is your workbook still open If no workbooks are open, repeat with Quit and destroy your exlApp Regards, Peter T "Namrata" wrote in message ... Thanks for reply ! I change the code as: excelWorksheet = null; ensure all unsaved wb's are closed, after saving or with close false excelWorkbook = null; exlApp.Quit(); exlApp = null; But excel file still remains open. "Peter T" wrote: Only a guess but try changing exlApp.Quit(); exlApp = null; excelWorksheet = null; excelWorkbook = null; to - excelWorksheet = null; ensure all unsaved wb's are closed, after saving or with close false excelWorkbook = null; exlApp.Quit(); exlApp = null; Regards, Peter T "Namrata" wrote in message ... Hi, I am using Excel for reporting. For opening excel file I have write code : exlApp = null; exlApp = new ApplicationClass(); //try //{ object missing = System.Reflection.Missing.Value; string path = oString(); excelWorkbook = exlApp.Workbooks.Open(path, missing, 1, missing, Excel.XlTextQualifier.xlTextQualifierNone, missing, missing, missing, true, //COMMA missing, missing, missing, missing ); path = ""; path = (); path = path + @"\" + frmSiteName.siteName + " GenSumm " + DateTime.Now.Day + "_" + DateTime.Now.Month + "_" + DateTime.Now.Year + " " + DateTime.Now.Hour + "." + DateTime.Now.Minute + ".csv"; excelWorkbook.SaveAs(path, missing, missing, missing, missing, missing, XlSaveAsAccessMode.xlNoChange, missing, missing, missing, missing); object pwd = "cgclogic"; excelWorkbook.Unprotect(pwd); Excel.Sheets excelSheets = excelWorkbook.Worksheets; excelWorksheet = (Excel.Worksheet)excelSheets.get_Item("Log Report"); excelWorksheet.Unprotect(pwd); And before that form termination, write code : excelWorkbook.Save(); exlApp.Workbooks.Close(); exlApp.Quit(); exlApp = null; excelWorksheet = null; excelWorkbook = null; This form is opening through MDI. But even after form close 'Windows Task Manager' is showing 'Excel' in process. And after application colse it is removing from task manager. When that file in the reports folder try to open, it is giving error : " This file is already opened . DO you want to reopen the file ?" or " This file is being modified by other user . Open a read-only copy." please tell how to close that file using code. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Re-show userform after closing file - code help | Excel Discussion (Misc queries) | |||
How to code on Macro on saving and closing a file? | Excel Worksheet Functions | |||
code for closing out an excel file while in the browser? | Excel Programming | |||
Macro Code for closing excel... | Excel Programming | |||
Problems closing Excel correctly by code | Excel Programming |