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
Bookmarks