View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
xs xs is offline
external usenet poster
 
Posts: 3
Default How to open many excel files efficiently

Sorry I forgot to mention that I am using C# to open them.
Thanks.
"xs" wrote in message
...
Hi,

I tried opening 50+ files using the Open method at theWorkbook class at
one go. However due to the size of each file, which average about 2 MB,
the process takes too long to open. Is there a more efficient way to open
these files? Because each file takes about 5 mins to process and open. I
have tried opening a file, process it and closing it. But it doesn't make
any difference. Is there a way to open 1 excel process and use that
process to open the rest of the excel files? That should be the best way
to open and process them right?

Regards
xs