I had a similar problem, only I was retrieving data from several Excel sheets. I found that when I was done with the Excel app, I had to do the following:
xlApp.Quit()
xlApp = Nothing
GC.Collect()
GC.WaitForPendingFinalizers()
Apparently, the garabage collection in this particular instance needs to be forced. Hope this helps!
=================================
She stood on the bridge at midnight,
Her lips were all aquiver.
She gave a cought,
Her leg fell off,
and floated down the river.
|