Cleanup Downloads Folder

Do you prepare analytics by downloading a report, cleaning it up, summarizing it, and presenting it to your audience mostly using Excel? Say you’re looking to automate some of the steps using the power of VBA. How do you make sure your automated Excel App picks up the latest version of the downloaded report?