Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Can't quit?

Status
Not open for further replies.

sflau

Programmer
Oct 18, 2001
87
0
0
HK
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top