Access Error Using Excel COM Component

K

Karl Yates

I am trying to create a spreadsheet via the Excel COM Component in VB.Net.
The application works fine on my development machine, but when moved up to
the web server, I get access errors.

I have referenced the Microsoft Excel 11.0 Object Library, and in code have
tried instantiating the Excel Object 2 ways:
- Dim exApp As New Excel.Application
- exApp = CreateObject("Excel.Application")
Either way, I get the exception "Cannot Create ActiveX Component"...

I have tried going into dcomcnfg and given the ASPNet account both Launch
and Access permissions for the Excel Component. This has not worked.

Does anyone have any more suggestions? Thank you so much in advance.
-Karl
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working outlook via vba code with xlsx - error 0
VSTO C# add in Outlook.Appointment error 0
error: Object doesnt support this property or method 2
Deploying Excel com component on server did not work 0
Cannot Get Instance of Com component Microsoft.Office.Interop.Excel.Worksheetwith Excel Interface Er 5
Exporting multiple rows from access to excel, each in a new row 2
Excel 2010 Component Id 1
COM Class Error while accessing Outlook in VB.NET 1

Top