View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kyle Baley Kyle Baley is offline
external usenet poster
 
Posts: 7
Default Opening and closing many spreadsheets from .NET

Interestingly, ReleaseCOMObject didn't do any good but GC.Collect fixed it. I took out the Thread.Sleep call and processing time dropped 40%. I think I'm going to switch to ADO.NET to get the info I need but this will come in handy when I start the more complicated stuff. Thanks.

Not sure if it's been mentioned here but this article helped out, too:
http://blogs.officezealot.com/whitec...s/2004_02.html