Opening Excel files and using cell values in formulas

Hello,

I'm creating an Excel file which lets the user choose if he wants the data with or without management override. The problem is that the data in the summary depend on 14 Excel files, so I have to open them all. So in the macro, I need to

1. Open all the Excel files
2. If Management Override is set to "W", set it to "W" in the 14 files. If it is set to "W/O", set it to "W/O".
3. Put the good values in the cells with .Formula="..."

I'm using something like this :

Please Login or Register  to view this content.

The problem is that it is very long to load (about 2 min for the entire macro). Is there a way to run it faster?

Thanks

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Code tags added this time only.