Hot Fox: [Access VBA Central] Hi Friends... WANT HELP REAGARDING VBA EXCEL...PLZ HELP

sexta-feira, 16 de abril de 2010

[Access VBA Central] Hi Friends... WANT HELP REAGARDING VBA EXCEL...PLZ HELP

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.