That was wonderful Brendan...Thanks a lot for taking your time and helping this novice.

If there are two or more directories should I keep changing path everytime?

I just have a weird thought, if path can be made dynamic, like when I run code, if system asks me for the directory then I can browse and select it. By which way, it will be helpful for everyone who doesn't know vb.

Moreover, we are only looking for .xlsx files in the code, if there are other type of excel files, wouldn't be useful to include all such??