Merging excel files

[Niket_Ghai]

Hey!
First use Read Range to read the excel files, then use merge data table activity to merge the data table…then use the resultant data table to make the merged excel file using WriteRange activity!
And this thread will help you to convert it into PDF

Converting an Excel file to a PDF /word file

can you try like this. open excel file send hot key F12 use desktop recorder and get the file name input box element in Save as dialog box. use input activity to send file name like this filename+(k[tab])p(k[enter]) – this will let u to select pdf option in format