I have a excel file which is macro enabled with a hidden sheet. i require the following work
1. Create a macro which will upload the data from the hidden sheet into a mysql database
[url removed, login to view] mysql database already has a table which matches the structure of the hidden excel sheet
3. the data must insert and update
4. if there is an error uploading/connecting the excel macro must not error. It must show a error to the user stating the upload was not successful
5. if the upload was successful a message needs to pop up to display successful
6. When the upload is successful the macro must also output a csv file of the data uploaded into a backup directory
7. the macro must be able to be configured to allow to switch between different mysql server IP's, user and password.
On success of awarding the project i will send the excel macro file to the awarded winner.
15 freelancers are bidding on average $513 for this job
I would like to apply to it. I'm a web developer with 7 years experience in PHP, MySQL, CSS3, HTML5 and deep knowledge WordPress, WP plugins, development issues