I'm using visual interdev and have the following code on my asp page.
Problem is i keep getting the following error :
"Active X component can't create object: 'Excel.Application' "
I have referenced the Excel 9.0 object library.
If anyone has any ideas on how to solve this never-ending problem ,
please let me know.
Thanks
CODE :
<P><INPUT id=button1 type=button value=Button name=button1>
<script language = vbscript>
sub button1_onclick()
Dim xlApp
Dim xlBook
Dim xlSheet
Dim xlButton
Dim oSheet
Set xlApp = CreateObject("Excel.Application")
Set xlBook = xlApp.Workbooks.Add
Set xlSheet = xlBook.Worksheets.Add
set oSheet = xlBook.ActiveSheet
xlapp.visible = true
etc
etc![]()
![]()
![]()
![]()
![]()




Reply With Quote