Hi all, I’m stuck to get the following done, hope to get help from any one of you
Download the excel files from website chrome for different companies a few times per week, move the files to folders that belongs to the companies respectively, so basically the files in that particular folder will continuously be updated.
- When I download the new excel from the website, I need to get the previous updated excel file in that particular folder (?what activity should I use)
2.Compare the current excel and the previous updated
- Extract the differences(new rows) to a new sheet/workbook
Should I move the file once downloaded instead of trying to download it all? If so, may I have an example how to move file to folder respectively (how to let it detect the company’s name and move it ?)