Importing from Excel

[ChrisLindsell]

I use an excellent piece of code to import from an excel spreadsheet into a Notes view, courtesy of Cat Kat, which I picked off the Iris Sandbox.
Unfortunately there is a small problem with the code. Although the code tells excel to close and free up the memory it was using with the statements - "Excel.Quit" and "Set Excel = Nothing", there is still an excel process running with about 4 MB of memory attached to it.

Anyone got any idea of how I can make sure that excel shuts down cleanly?????

 

[Kendertaunt]

Is the code using Excel as an ActiveWorkbook?
If so, try

xlapp.ActiveWorkbook.Close

Jess

 

[ChrisLindsell]

Hi Jess,

Thanks for the idea.....
but it still leaves the process open !

Chris