Hi..

I am having multiple excel files around with some formatting like merged. i want to merged all these file into one excel sheet, can anyone provide me vba code to do the same. all the column are same in all the files.

Thanks in advance..