On our intranet we have a function that does a fairly complex search for
"things". I won't bother you with what our "things" are, but one "thing" can
be described as one row in Excel (like Id, Date and Description). The result
of the search is normally just presented in the web browser as a set of rows
but occasionally the users want to
1. get the results into Excel
2. run a predefined macro that controls PowerPoint (using the aforementioned
data) and thereby create a more visual description of our "things" used in
company presentations.

I can generate an Excel file from my ASP code. The problem is the macro I
must apply to the data. For now the users must have the Excel file with the
macro, copy the data from my ASP-generated Excel file into it and then run
the macro. I would like to generate an Excel file with the data AND the
macro!

I looked at saving my Excel macro file in HTML and thought I could take the
code and put it in an ASP file, but that does not seem to be feasible.

What to do?

Regards,
Jonas B

Hi Jonas,

I just ran across this post and thought of you. "Reading and Writing Excel
Spreadsheets Using ADO.NET C#" :
DbProviderFactoryhttp://davidhayden.com/blog/dave/archive/2006/05/26/2973.aspx

Don't know if this helps but it seems related.

Kim