Closing Excel Instance

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

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

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-programmer>LoodS</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
>
>

"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" <[email protected]> wrote in
> message news:[email protected]...
> >
> > 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