The code I am using is as follows:
Dim myApp as Excel.Application
set myApp = new Excel.Application
myApp.Visible=True //so I can see it close
...code to read in some data
Then, I have tried the following, none of which work to remove the Excel process from memory...
1. myApp.quit (or close)
2. myApp.Application.quit
3. myApp.Workbooks.close
Then...
set myApp = Nothing
This successfully closes the window, however, the 'Excel' process remains in memory and causes Access to hang. Thank you for your reply, this problem is really bugging me.