Hello ,

I am a novice in a VBA excel and i am facing a problem which is as follows:  I need to open 50 xls files and store its filename as erray function  so that i can use it for further calculation.

Thanks