Use this project as a reference to automate tasks across all Excel files on a folder. This project performs a set of automation tasks on all files situated in a folder on OneDrive-Business (can also be used for SharePoint folder). It performs calculation on the manual Excel calc files, adds formatting and inserts a comment with at-mention note to a colleague.
Download Excel files and upload to a folder titled Sales.