I need to take an Excel spreadsheet and display it on a web page. The spreadsheet needs to retain all Excel functionality. I'll worry about that after I solve the problem of actually displaying it. I searched this section, as well as the web in general, and pieced together the following code that seems to work well for other people, but is giving me an error.
Code:
<html><head>
<script language=vbscript>
Dim objExcel
Dim oxlBook
Sub chartsheet_onclick()
call OpenWorkbook("PathToMySpreadsheetOnNetworkFileServer\MySpreadsheet.xls")
End Sub
Sub OpenWorkbook(strLocation)
Set objExcel = CreateObject("Excel.Application")
Set oxlBook = objExcel.Workbooks.Open(strLocation, false, true)
objExcel.Visible = true
objExcel.UserControl = true
objExcel.Sheets("Issue_List").Visible = True
End Sub
</script>
<title></title></head><body><br>
this is a test page for displaying an excel spreadsheet
<br><br>
<input type=button name=chartsheet value="display excel spreadsheet">
</body></html>
The error I get is "ActiveX Object Can Not Create Excel.Application" - Yet, I see the exact same code in example after example after example. Is there something behind the scences that I am not aware of?
Reply With Quote