Open multiple files simultaneously

[selvivp]

I have an applcation that opens about 160 files does some processing and closes the files. Most of processing time is on the opening and closing of the files. How can I achieve multithreading for opening and closing of the files? This is an Excel VBA application and I am running of Excel 2007.

 

[kpark91]

I don't believe you can unless you decide to merge the files.

The reason is because computer will perform one task at a time no matter what... I am not sure but you might be able to with more than one processors????

There may be ways to open the files faster but that's about it...