Combining Multiple Workbooks data in one workbook

[Niraj Baraili]

I am new to VBA Programming and I am trying to learn it thoroughly. I want to write a code as per the attached excel file when i clicked on input - select files, it will open the files which i need to select for merging and when i click output-select files it will open destination file where i want to save the merge files. And finally when i click consolidate, it has to start merging the files and finally give message that data consolidation is done.

I tried a lot with the previous post and unable to find a solution.

Hope will get a solution or idea.

 

[Luke M]

Hi Niraj, and welcome to the forum!

I'd recommend starting by reading some of Ron's code here:
http://www.rondebruin.nl/win/section3.htm

He's written many excellent examples of merging/copying, and all of his code is well commented. You should be able to either use his pre-built code, or use it to modify your own. Either way, it would be a good learning exercise.

 

[Niraj Baraili]

Hi Luke,

Thank you very much.
I think i will be able to find a solution for this from this Link.