View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin Beckham Kevin Beckham is offline
external usenet poster
 
Posts: 78
Default EXCEL.exe stays open after Quit method in an HTA

Oops.

Should be

xlObj.Application.Quit

Kevin Beckham

-----Original Message-----
I'll move my code to VBScript
as it seems to behave better. Have no idea how to set the
value to nothing on JSCript
Perhaps undefined?


-----Original Message-----
In the scripting environment that I've used, try

Var xlObj

Set xlObj = GetObject("workbookname.xls")
or
Set xlObj = GetObject("", "Excel.Workbook")
then

xlObj.Quit
Set xlObj = Nothing

Kevin Beckham

-----Original Message-----
Im trying to close the Excel.exe that is open in my
Processes .Imm usng JSCRIPt and VBScript,

var ExcelApp =new ActiveXObject ("Excel.Application") ;

....
ExcelApp.Quit();
//ExcelApp = null;
NAR (ExcelApp);

<script lanugae = "VBscript"
Sub NAR( ByVal O)
Set o = Nothing
End Sub

Still my Processes show an instance open

How can I do this? Any help?
Need to save 35 times and can't have 35 instances of
Excel .exe running


.

.

.