Crazy Boss Request - HELP PLEASE?

ok. have an excel spreadsheet that users of the web site can plug in a number (mortgage balance) and it performs calculations (annual payments). users then click an 'apply now' link which takes them (seperate html page) to an online application.

am using CDONTS and asp to send the app to both an email address and a database.

my boss is insisting that i find a way to transfer the results of the spreadsheet on page1 to form fields automatically (page2) to be sent with the email.

we are a straight Microsoft shop unfortunately btw.

is this possible? anyone have any ideas?

BTW, am still fairly new to asp but am catching on quickly.

Seeing if I understand you: the user currently does something in excel. Is this on their computer? Then they click a link and go to the online form. You want to populate some of the form with data from the spreadsheet on the user's local computer? Or is the Excel sheet somehow being accessed online?
If the Excel sheet is on the client computer, you're going to have a hard time doing this. If its on the server, we can talk

but i THINK i have found a work around. i have dumped the excel and have written an ASP form. they input their mortgage balance and then would be taken to a page with the mortgage app.

am currently having trouble pulling the variable value over though to the new ASP page/new form. my problem is that the "index page" (with the calculation form) is in a sub folder on our server and the "application" page HAS to be in our wwwroot folder (due to the ONE verisign secure license we own). that means (at least to MY little knowledge) that a Global.asa file won't work in this case (i run about 15 web sites and ALL are using ASP files and CDONTS to write to email AND Access at the same time)

appreciate the help. i am making progress but slowly.

OR (if complex calculations are going to be a problem ((%, /, etc...)) and i HAVE to go back to the Excel way, got any suggestions?