Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing Excel Instance
Hi I am Rajesh I want to display an Excel file <file.xls in Internet Explorer 6.0. am currently displaying the xls file in the browser using javascrip code in the click event of a button. The problem is that when I close the browser, the excel instanc remains in the list of processes in Task Manager. Please help me how I can close that instance. Any suggestion or hin will be of great help to me. Thanks in Advance Rajes -- harki ----------------------------------------------------------------------- harkit's Profile: http://www.excelforum.com/member.php...fo&userid=2576 View this thread: http://www.excelforum.com/showthread.php?threadid=39179 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing Excel Instance
This usually is caused by creating a reference to Excel which is not
released. This can be done by using a construct like xlapp.ActiveSheet.Sort Range("A1") where the reference to cell A1 is not fully qualified. xlApp.Activesheet.Sort xlapp.ActiveSheet.Range("A1") would be the proper way to do it. If you are only displaying the sheet, then perhaps this is not applicable - but you may otherwise not be releasing your reference. -- Regards, Tom Ogilvy "harkit" wrote in message ... Hi I am Rajesh I want to display an Excel file <file.xls in Internet Explorer 6.0. I am currently displaying the xls file in the browser using javascript code in the click event of a button. The problem is that when I close the browser, the excel instance remains in the list of processes in Task Manager. Please help me how I can close that instance. Any suggestion or hint will be of great help to me. Thanks in Advance Rajesh -- harkit ------------------------------------------------------------------------ harkit's Profile: http://www.excelforum.com/member.php...o&userid=25764 View this thread: http://www.excelforum.com/showthread...hreadid=391796 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing Excel Instance
If you created the Excel instance as an object you have to destroy the object
when you're done with it. In VBScript it would have been something like "Set myApp = Nothing". Hope this helps. -- <vba-programmerLoodS</vba-programmer "harkit" wrote: Hi I am Rajesh I want to display an Excel file <file.xls in Internet Explorer 6.0. I am currently displaying the xls file in the browser using javascript code in the click event of a button. The problem is that when I close the browser, the excel instance remains in the list of processes in Task Manager. Please help me how I can close that instance. Any suggestion or hint will be of great help to me. Thanks in Advance Rajesh -- harkit ------------------------------------------------------------------------ harkit's Profile: http://www.excelforum.com/member.php...o&userid=25764 View this thread: http://www.excelforum.com/showthread...hreadid=391796 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing Excel Instance
"Tom Ogilvy" wrote: This usually is caused by creating a reference to Excel which is not released. This can be done by using a construct like xlapp.ActiveSheet.Sort Range("A1") where the reference to cell A1 is not fully qualified. xlApp.Activesheet.Sort xlapp.ActiveSheet.Range("A1") would be the proper way to do it. If you are only displaying the sheet, then perhaps this is not applicable - but you may otherwise not be releasing your reference. -- Regards, Tom Ogilvy "harkit" wrote in message ... Hi I am Rajesh I want to display an Excel file <file.xls in Internet Explorer 6.0. I am currently displaying the xls file in the browser using javascript code in the click event of a button. The problem is that when I close the browser, the excel instance remains in the list of processes in Task Manager. Please help me how I can close that instance. Any suggestion or hint will be of great help to me. Thanks in Advance Rajesh -- harkit ------------------------------------------------------------------------ harkit's Profile: http://www.excelforum.com/member.php...o&userid=25764 View this thread: http://www.excelforum.com/showthread...hreadid=391796 Hi, You also can try these tips : - if your Excel file is displayed in an Frame or Iframe, clean the Frame by frame.location="about:blank"; - try the CollectGarbage method like this (found in an other javascript newsgroup post) excelapp = new ActiveXObject("Excel.Application"); ...... excelapp.workbooks(exlfilenames).Close(); // for all workbooks excelapp.Quit();excelapp=null; idTmr = window.setInterval("Cleanup();",5); function Cleanup() { window.clearInterval(idTmr); CollectGarbage(); window.close(); } -------- Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Closing workbooks w/o closing Excel | Excel Discussion (Misc queries) | |||
Excel - New Instance | Excel Discussion (Misc queries) | |||
Closing VB triggers closing Excel | Excel Programming | |||
Excel Instance | Excel Programming | |||
closing excel after closing a workbook | Excel Programming |