To retrieve a single cell's value for all Excel files in a folder

Oh and go to this link to see how to disable the message

http://answers.microsoft.com/en-us/o...a-e60b4633ed51

And... If i41 is always a number maybe declare myval as an integer instead. I declared it as a string and it worked fine on my test runs but changing to an integer might sort the mismatch out