| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Slow Opening & Odd Closing | New Users to Excel | |||
| Closing a workbook upon opening another | New Users to Excel | |||
| Opening and closing workbook with VBA... | Excel Programming | |||
| Opening and Closing workbooks | Excel Programming | |||
| Opening and closing text files | Excel Programming | |||
Hybrid Mode
