I am using VB 6.0 to control Excel for to do some thing, and then save as a new file. But I find that the excel application is still holding the excel, although I already quit it. Would anyone help me, please? Here is my coding:
--------------------------------------------------------
Dim DNxlApp As Excel.Application
Set DNxlApp = New Excel.Application
DNxlApp.Visible = True
DNxlApp.Workbooks.Add
...
DNxlApp.ActiveWorkbook.SaveAs FileName:="C:\XXXXX.xls", FileFormat:=xlNormal
DNxlApp.Workbooks.Close
DNxlApp.Quit
Set DNxlApp = Nothing
--------------------------------------------------------
But after I set the Excel Application as nothing, the application until existing, unless I quit the VB program.
--------------------------------------------------------
Dim DNxlApp As Excel.Application
Set DNxlApp = New Excel.Application
DNxlApp.Visible = True
DNxlApp.Workbooks.Add
...
DNxlApp.ActiveWorkbook.SaveAs FileName:="C:\XXXXX.xls", FileFormat:=xlNormal
DNxlApp.Workbooks.Close
DNxlApp.Quit
Set DNxlApp = Nothing
--------------------------------------------------------
But after I set the Excel Application as nothing, the application until existing, unless I quit the VB program.