I am trying to read only the 1st sheet of all the excel files in a directory. But the problem is while using read range I have to specify the sheet name but the sheet names are different for all the excel files. How can I ask it to read only the 1st sheet irrespective of the name in the for each loop?
@jamnanin
Try this in place of sheetname in Read Range Activity
Excelsheet1=xlwbook.Sheets.Item(1)
Regards,
Mahesh
I am getting an error on this