ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Access Error Using Excel COM Component (https://www.excelbanter.com/excel-programming/319634-access-error-using-excel-com-component.html)

Karl Yates[_2_]

Access Error Using Excel COM Component
 
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



Tim Williams

Access Error Using Excel COM Component
 
Is Excel installed on the server?

Tim.


"Karl Yates" wrote in message
...
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





Karl Yates[_2_]

Access Error Using Excel COM Component
 
Yes it is... Sorry, I forgot to mention that...
Thanks again...


"Tim Williams" wrote:

Is Excel installed on the server?

Tim.


"Karl Yates" wrote in message
...
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






Tim Williams

Access Error Using Excel COM Component
 
Well, that was my only guess - not really any experience with .Net

Tim.

"Karl Yates" wrote in message
...
Yes it is... Sorry, I forgot to mention that...
Thanks again...


"Tim Williams" wrote:

Is Excel installed on the server?

Tim.


"Karl Yates" wrote in message
...
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









All times are GMT +1. The time now is 06:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com