Search using for loop

I am stuck in doing this task, please help me

Read the excel file, loop through the row items and fetch them one after one processing them by searching in linkedin and extract the corresponding correlated date. now this data is to be appended to the same excel .

I am confused to use the loops. please help me

Read your input excel to datatable, dtExcelinput
Add a datacolumn to your dtExcelinput called Date
Then go on a For Each row of dtExcelinput
<–search linkedin code part goes here which retruns corresponding date, strDate–>
dtExcelinput(“Date”) = strDate

Outside the loop, write range dtExcelinput to the same excel filename

1 Like