Hi All,

I have codes in an Access project to open an Excel file and get data from it. Following is the excerpt of my codes.
    
    Dim xlApp As Excel.Application
    Dim xlBook As Excel.Workbook
    Dim xlSheet As Excel.WorkSheet

    Set xlApp = CreateObject("Excel.Application")
    ....
Even though I have Set xlApp = Nothing at end of sub to release variable from memory, I still found many instances of EXCEL.EXE from Windows Task Manager and they are all left-over from my sub. What's the right way to close EXCEL after a procedure?

And during the whole process, the Excel workbook is invisible to me. How can I show the workbook to the user?

Thanks & Merry X'mas

Huyeote