Click to See Complete Forum and Search --> : error when opening an excel spreadsheet


vbnov
July 26th, 2006, 04:00 PM
works fine in my localhost. but here is the error that I get when I try to open an excel spreadsheet.

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154.

Source Error:


Line 218: Dim intRow, intCol As Integer
Line 219: Dim status As String
Line 220: Dim oXL As New Excel.Application
Line 221: Dim oWB As Excel.Workbook
Line 222: Dim oSheet As Excel.Worksheet

error is in Line 220


Any ideas?

superuser
July 30th, 2006, 08:50 AM
Is excel installed on the web host server?

vbnov
August 1st, 2006, 09:41 AM
No, Excel is not installed on the web host server. Could that be causing the error?