Hi all,
i write a export excel function ... Can generate a excel file in screen, if close it , the user can select save or not save.......
But anyway user save and quit the excel or direct quit excel...... i find the task manager still exits excel.exe,
how can i do, thx?

  Public Sub genexcel()
        
        Dim XL As Excel.Application
        Dim WB As Excel.Workbook
        Dim Sheet As Excel.Worksheet

        XL = CreateObject("Excel.Application")
        XL.Visible = True

        WB = XL.Workbooks.Add

        Sheet = WB.ActiveSheet
        Sheet.Activate()



       XL.Visible = True

        XL.UserControl = True

        Sheet = Nothing

        WB = Nothing

        XL = Nothing