Hi,
I have an ASP page that looks up data from an Access database and displays it on screen.
I wish to be able to offer the user the option to save this data as an Excel spreadsheet.
I have set up the Export to Excel using OWC11, but I am having trouble transfering some variables from the original ASP page into the OWC11 spreadshhet object / ASP page that makes the XML data to export as an XLS.
I have four variables that need to be transfered. A customer number, a start date, an end date and a save as name.
Does anyone now how to send variable data to an OWC object.
I need to 'post' the data to this address through this object.
Any assistance you can offer would be most welcomed thanks.
Barry
ICT Network Administrator
IT Services Manager
Barry
ICT Network Administrator
IT Services Manager
I have an ASP page that looks up data from an Access database and displays it on screen.
I wish to be able to offer the user the option to save this data as an Excel spreadsheet.
I have set up the Export to Excel using OWC11, but I am having trouble transfering some variables from the original ASP page into the OWC11 spreadshhet object / ASP page that makes the XML data to export as an XLS.
I have four variables that need to be transfered. A customer number, a start date, an end date and a save as name.
Does anyone now how to send variable data to an OWC object.
Code:
<object classid="clsid:0002E559-0000-0000-C000-000000000046" id="Spreadsheet1">
<param name="XMLURL" value="groupstatsexport.asp">
</object>
I need to 'post' the data to this address through this object.
Any assistance you can offer would be most welcomed thanks.
Barry
ICT Network Administrator
IT Services Manager
Barry
ICT Network Administrator
IT Services Manager