Hi,
I've excel workbook containing vba, this workbook does some complex
calculations when some data is send to it (or paste) these calculations
are based on vba as well as functions.

My problem is that i've to run this on web server (as COM component)
send some data to it and extract data.

I'm thinking on these lines, open excel template file (visibility
should be hidden) send some data to it, perform calculations, extract
data from it and generate word and pdf reports based on extracted data.
Now i know using word and excel as COM is problem on server as it may
hang in memory and not easy to clean efficiently.

I need expert advise from you guys to :
1. Summarize the process in efficient manner (maybe alternate solution)
2. Risk associated and to bypass it
3. and overall feasibility of the solution

I'm using ASP.NET on server

regards,
Shattar