PDA

View Full Version : Copy contents from various excel files in a folder and merge



rajagopal
07-27-2010, 02:43 AM
Many .xls files are stored in a server location;
1. Browse dialog box has to appear automatically (can display current folder location) and has to list down all the excel files available in the selected server location;
2. User can select all or multiple or any one of the file (selection can be done by radio button or check box)
3. All the .xls files have many sheets but my requirement is to copy the entire contents available in “Raw data” and paste it in a new excel file (referred as master file)
4.Likewise, the contents in other .xls files have to be copied and appended below to the existing data in the master file.
5.The header row (Date, ID, Project…) in “Raw data” sheet is same in all the .xls files and hence the header row need to be copy, pasted only at the top and need not be repeated during append.

i've attached the sample for your ref. Thank you..