Release Variable from Memory Problem

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.

Please Login or Register  to view this content.

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

It works. Thanks.

Any idea why the application is invisible to user?

Huyeote