Copy data from 3 diffrent .xls files to one .xls file on diffrent sheet
i have already created 3 xls files which having only one sheet in it.
now i need to merge or copy the the each 3 files on new .xls files with diffrent sheet. for example file 1 data will be copied on sheet 1 of new file and so on
these 3 files can have diffrent range set so i can't write the code which only depends on the range and copy it.
is there any way to do it directly
Exlapp := TExcelApplication.Create(Self);
ShowMessage('File Created Successfully');