I need the ability to send form results to an excel (.xml) spreadsheet then email the user that particular spreadsheet with all the new data in it. However before the email attachment goes out to the user, they are going to be directed to PayPal where they will buy the excel file. I already have the excel file and HTML form built. The excel spreadsheet i built already has all the calculation formulas in there that a person needs. I need you to build me the code that will do all of this for me.
Here is how it should all work in the end...You are responsible for making the following come true.
***Remember i am giving you both the excel file and the HTML form****
When the internet user completes the form online, he/she will be brought to my PayPal page where he/she can buy the spreadsheet. After payment is complete, the user will receive an email with the attached spreadsheet. Inside the spreadsheet will be all of the date that user entered into the form. The excel document will arrive as a "locked" workbook, this way users cannot modify the rows and column for continual future use. Also the formulas in the Excel file need to be hidden so that users cannot see how the data is calculated. The locked spreadsheet will contain all of the data the user entered from the online form plus some empty unlocked cells where the user can enter their score later on that day.
You are responsible for the following:
Sending the user to my PayPal page to buy the form first.
Setting it up so that the user can purchase spreadsheet on PayPal or via credit card.
Taking my form and making the form results go to particular cells in Excel.
Sending the excel file as an email attachment to the user.
Excel file that is send will need to have certain cells "locked" and other cells "unlocked". The calculation formulas will need to be hidden from the user.
***For this project to be completed, it will need to work just as i described in the second paragraph above on my server. Also you are responsible for loading the information on my server and making sure it works as described above. I will send you my server login information so that you can load and test.
Here is an example of how the form fields will go into excel...
HTML Form Fields -- EXCEL File
First Name -- Cell A2
Last Name -- Cell B2
Email -- Cell A3
Phone -- Cell C1
***Don't worry I will let you know what cells the form fields are going to. (e.g First_Name --> Cell A2)***
Also the individual cells (A2, B2, A3, C1) in the EXCEL Attachment needs to be "locked" when it is sent so that the user cannot modify the data.
****Here is some information about my current server***
Operating System: Windows
.Net Runtime Version: [url removed, login to view] 2.0/3.0/3.5
PHP Version: PHP 5.x
IIS Version: IIS 7.0
SQL Server Databases: 1 Available
MySQL Databases: 1 Setup of 10 Available
Shared Hosting Server with Godaddy.
10 freelancers are bidding on average $149 for this job
Expert in doing this sort of stuff... No upfront needed, all payments through GAF Milestone Payment (Escrow).. Online 16 Hours a day, Can start right away.. Thanks