Curl Excel auto load file from ftp site to a server
£20-250 GBP
Closed
Posted almost 11 years ago
£20-250 GBP
Paid on delivery
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]
thanks
Hello
Depending on whether you want to run this script on Windows or Linux, I can build you either a C# or PHP script to automate the Excel download and macro execution. I've completed similar projects using Windows services and file watchers to trigger automatic file loads; and Excel automation to run the embedded macro.
I can complete this project and deliver the script, working to your specifications and fully-tested, within a few days and I am available to start on this project immediately.
Best regards
Brent
I am Data Entry Expert, MS Word and MS Excel. i am very much professional in this work i am pretty sure that you cant find a best person for this job like me so i am ready to work on your project with low rate and high quality.
Sure, this could be done really easy (an hour or two once I know the full details). I'd probably use powershell to keep everything simple. I'm brand new to freelancer so pretty keen to gain some reputation (happy to chat on Skype or via phone).