Web / Excel intergration

[mabsher]

Can someone give me a primer on the following:

I have a .xls file that validates subcription codes on my computer that vaildates output from code in another user's .xls file. The code that deciphers that output can easily be expressed at VB Script. But the VB Script would need to read and write information from the script back to the workbook on the server.

I need an html form to collect three pieces of information from the customer, use that input to include in the code, and then output info from the script back to the user presumedly in html, and write the information to the workbook on the server.

Is this possible?

 

[AncientTiger]

Sounds to me more like a Database solution than a spreadsheet file. Have you ever considered converting these sheets to Access DB files, the using SQL to read/write info to them?

 

[bsquek]

Hi...

I am writing a asp program which can download my data from the SQL database to a excel file. However I don't know how to set a password on the excel file from the asp function. an anyone help me?