Hi all,

I want to give users the ability to fill out a web form and get a few dynamically-generated charts to display on the web. I have the excel macro-ing done, and I have a website with a form that can take input and make SQL queries in ASP, so my connection the the database is solid.

I was hoping for a strategy discussion: does it make sense (and is there a way), to invoke excel from an ASP script to open, run some numbers, generate graphs and then export them for display? I imagine this is possible, but before I go into too much work I was hoping to hear from the experiences here to find out if anyone has had success doing this type of thing in the past and what route they went and what they would recommend.

Thanks.