Author: kldeutsch | Posted on: 9/2/2008 6:23:37 AM | Views : 275

I am working on fixing a project, what happened is that the excel export function broke when we blocked active x controls.  So what I am trying to do is get a ASP.net data table to export to excel.  THe original code was written in Vb script.  I know how to do a datagrid to excel but not tables, tried to use datagrid examples but they never work.  This is existing vb script, how can I use code behind with the export button to call this function and export the table.  Thanks  This is the error I get with the existing function

Line 55

Char 5

ERROR: Active X component can't creat object: Excel Application

This is the line it calls out           Set oExcel = CreateObject("Excel.Application")


 

<script language="vbscript">
 Sub exportbutton_onclick
   
  Status = "Processing ....."
&n ...

Go to the complete details ...