On 1 Sep 2005 06:22:44 -0700, "smonczka" <smonczka@g...> wrote:

>He designed a ASP.Net page that pulls info about our clients and the
>products they bought from our SQL back end.  I created a Excel PO
>worksheet that the employees fill out to submit an order.  What we were
>trying to do is push info from the ASP page into the Excel order form.
> They pull up the ASP page, locate an existing client and push a button
>that brings up the order form and fills in the client information.  The
>Data is always in the same place on both the ASP page and the order
>form.

That sounds almost ideal to use XML+XSL and make an officeXML
document. I do this quite regularly here, you just need to save your
Excel "template" as XML (in Office 2003) then convert it to an XSL
stylesheet which "fills in the gaps" from an XML recordset created in
.NET. 

Have a look at a saved Excel XML file in a text editor, it's a pretty
straightforward structure and you should be able to see immediately
which elements you need to add <xsl:value-of select="blah" /> to, in
order to generate your output file. 

You'll need to send the following headers from .NET 

Content-type: application/vnd.ms-excel
Cache-Control: no-store, no-cache, must-revalidate
Pragma: no-cache
Expires: 0

Then send the results of transformToObject() with your XML file and
XSL stylesheet.

HTH
Cheers - Neil


>We used VB to create our first version and it work properly till we
>tried it on a system other than the one it was developed on and ran
>into security issues, VB could not create the object remotly, in other
>words VB on the web pages could not create the Excel sheet.  We even
>tried .Net Remoting at one point and still ran into security issues.
>
>Thanks for any direction you can give us on this one.  :)
>
>Steve