I need to download four csv files to a specified folder on my hard drive daily. I have the address in an excel file, the url is dynamic, so needs to be updated daily; the code for achieving this I have programmed into the Onopen event of the excel, so the excel needs to be opened at a certain time each day, the url of the file is copied into memory. I was suing winautomation to open the excel, then open the browser, past the url into the formula bar, press enter and download the csv to the folder (slight manual input was needed to click OK to download the csv).
I want to move this to the next level and totally automate the download, so I need someone who can schedule for the excels (4 of them) to be opened one at a time which will put the url in memory and then download the csv to the relevant file. Once all four have been doonloaded a specific excel needs to be opened.
I will have a number of projects so if i can find a good programmer i can work with there will be other work. One majorish project is to translate a programme i have in excel to a web platform.