HI, I am new tom VBA .
First of of all, please see the attached JPEG File. I want to do same for merging 10-25 Excel in single excel sheet. Functiona of Buttons in Given In User form should be like this ADD FILES ; When user click on this command button , it should ask me path for excel file to open as described in JPEG NO 3. REMOVE : When user click on Remove Command button, it should remove all previously added files from the list. As described in JPEG NO 3. CLEAR ALL : When we started new session, there may be some file are listed in Add Excel Files List box that we added last time. When user click on this button , all excel files that are listed in ADD Excel files should be get clear. JOIN : This command button Joins or merge all files one after another that you have added to Add Excel Files list box. Just before. NOTE : This user form should open when we click on one button in excel that is names As "Compile Data', then only this macro runs step by step as mentioned earlier.
