I have an excel file that manipulates data from a raw excel format file to a clean summarised excel formatted file by clicking a button inside the excel file that runs the macro. Then I click a button in the excel spreadsheet it already creates the 'new' excel file. At the moment someone has to click the button every day and publish it to a server. Here is what I want automated.
1. The file is sent via FTP to a directory
2. Once arrived I want it to execute the macro that converts the raw data and creates a new file in the same directory
3. I need, via a CURL script, the NEW file to be published to a server. (cannot share server username/password - just leave in script text [user] [password]