I am trying to automate one web page,for that i am getting data from email in execel file, like i need to create order ,for every order i have seprate excel file to complte order on web.
bot saving excel attachmenets in folder and from that folder bot should take excel “cell” data in variable and from variable to web page.
How can i store values dynamicaly using for each loop, for if i am having 5 files in folder but their name bot don’t know it should take data for first order from first excel from folder …for second order data should be from second execl?
Please help!!!Thank you in advance.