html asp form excel file question?

[cisco777]

I have only worked with asp and vb script every couple of years for a very small period of time each time. I am trying to determine what may be the best process for:

I needed to create a html form - this done and working

Then I am suppose to create an excel file and email this excel file as an attachment.

Quandry -

I already figured out how to use asp to create an excel file that opened in the browser but this is not what is needed.

Instead I need to create an excel file that can be sent via email as an attachment.

I believe I just figured out how to write on the server this excel file. I found the file has to be on a server and Not on a local computer.

Therein is the problem.

I believe this excel file may contain data that not everyone should see.


Is there a way I can create a temporary excel file from the asp input that came from the form. And then email this temporary file so that it does not remain on the server?

Or is there a better approach?

Thank you in advance for any assistance with this.

 

[markdmac]

Alter your approach a bit.

You can use ADO to write to Excel. In this way you connect to an Excel Spreadsheet like a SQL database.

You can create a resource account that the web page uses for anonymous access. Then restrict read access of the spreadsheet using NTFS permissions to your admin account and give the newly created resource account write rights to the file. While users access the page the script within it will run as the resource account, but a user trying to browse to the Excel spreadsheet would have no rights to it.

Examples of using ADO are here:

http://support.microsoft.com/kb/278973

I hope you find this post helpful.

Regards,

Mark

Check out my scripting solutions at

http://www.thespidersparlor.com/vbscript

Work SMARTER not HARDER. The Spider's Parlor's Admin Script Pack is a collection of Administrative scripts designed to make IT Administration easier! Save time, get more work done, get the Admin Script Pack.

 

[cisco777]

Thank you I am reviewing this url.