ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Microsoft.Office.Interop.Excel myexcel = new EXCEL.Application() (https://www.excelbanter.com/excel-programming/434510-microsoft-office-interop-excel-myexcel-%3D-new-excel-application.html)

samsonk

Microsoft.Office.Interop.Excel myexcel = new EXCEL.Application()
 
I keep getting the error message when trying to execute

Microsoft.Office.Interop.Excel.Application myexcel = new
Microsoft.Office.Interop.Excel.Application()

In the bigining the error message was

Retrieving the COM class factory for component with CLSID
{00024500-0000-0000-C000-000000000046} failed due to the following error:
80070005.


But after reading and implementing some blogs suggestions like
http://blog.crowe.co.nz/archive/2006/03/02/589.aspx

The error changed to

Creating an instance of the COM component with CLSID
{00024500-0000-0000-C000-000000000046} from the IClassFactory failed due to
the following error: 8001010a

The application works perfect on my local the problem is on the hosting
server, windows 2003 server ( I have tried to give all the permission to
Network service administrator in DCOMCNFG and excel is installed on the
server too) but I keep on getting this error , from what I noticed every time
this line (Microsoft.Office.Interop.Excel.Application myexcel = new
Microsoft.Office.Interop.Excel.Application()

is Executed I see EXCEL.EXE on task manager with the corresponding user
name ,NETWORK SERVICE and then fail to proceed with the error message given
above


samsonk

Microsoft.Office.Interop.Excel myexcel = new EXCEL.Application()
 
Here is the error message again
Creating an instance of the COM component with CLSID
{00024500-0000-0000-C000-000000000046} from the IClassFactory failed due to
the following error: 8001010a
Thanks

"samsonk" wrote:

I keep getting the error message when trying to execute

Microsoft.Office.Interop.Excel.Application myexcel = new
Microsoft.Office.Interop.Excel.Application()

In the bigining the error message was

Retrieving the COM class factory for component with CLSID
{00024500-0000-0000-C000-000000000046} failed due to the following error:
80070005.


But after reading and implementing some blogs suggestions like
http://blog.crowe.co.nz/archive/2006/03/02/589.aspx

The error changed to

Creating an instance of the COM component with CLSID
{00024500-0000-0000-C000-000000000046} from the IClassFactory failed due to
the following error: 8001010a

The application works perfect on my local the problem is on the hosting
server, windows 2003 server ( I have tried to give all the permission to
Network service administrator in DCOMCNFG and excel is installed on the
server too) but I keep on getting this error , from what I noticed every time
this line (Microsoft.Office.Interop.Excel.Application myexcel = new
Microsoft.Office.Interop.Excel.Application()

is Executed I see EXCEL.EXE on task manager with the corresponding user
name ,NETWORK SERVICE and then fail to proceed with the error message given
above


Patrick Molloy[_2_]

Microsoft.Office.Interop.Excel myexcel = new EXCEL.Application()
 
you have a reference set to the object model?

"samsonk" wrote:

I keep getting the error message when trying to execute

Microsoft.Office.Interop.Excel.Application myexcel = new
Microsoft.Office.Interop.Excel.Application()

In the bigining the error message was

Retrieving the COM class factory for component with CLSID
{00024500-0000-0000-C000-000000000046} failed due to the following error:
80070005.


But after reading and implementing some blogs suggestions like
http://blog.crowe.co.nz/archive/2006/03/02/589.aspx

The error changed to

Creating an instance of the COM component with CLSID
{00024500-0000-0000-C000-000000000046} from the IClassFactory failed due to
the following error: 8001010a

The application works perfect on my local the problem is on the hosting
server, windows 2003 server ( I have tried to give all the permission to
Network service administrator in DCOMCNFG and excel is installed on the
server too) but I keep on getting this error , from what I noticed every time
this line (Microsoft.Office.Interop.Excel.Application myexcel = new
Microsoft.Office.Interop.Excel.Application()

is Executed I see EXCEL.EXE on task manager with the corresponding user
name ,NETWORK SERVICE and then fail to proceed with the error message given
above


samsonk

Microsoft.Office.Interop.Excel myexcel = new EXCEL.Application
 
Thanks Very much for your replay!
What Do you mean by "reference set to the object model" ? the code workers
perfect in my local!
the problem is in the server
"Patrick Molloy" wrote:

you have a reference set to the object model?

"samsonk" wrote:

I keep getting the error message when trying to execute

Microsoft.Office.Interop.Excel.Application myexcel = new
Microsoft.Office.Interop.Excel.Application()

In the bigining the error message was

Retrieving the COM class factory for component with CLSID
{00024500-0000-0000-C000-000000000046} failed due to the following error:
80070005.


But after reading and implementing some blogs suggestions like
http://blog.crowe.co.nz/archive/2006/03/02/589.aspx

The error changed to

Creating an instance of the COM component with CLSID
{00024500-0000-0000-C000-000000000046} from the IClassFactory failed due to
the following error: 8001010a

The application works perfect on my local the problem is on the hosting
server, windows 2003 server ( I have tried to give all the permission to
Network service administrator in DCOMCNFG and excel is installed on the
server too) but I keep on getting this error , from what I noticed every time
this line (Microsoft.Office.Interop.Excel.Application myexcel = new
Microsoft.Office.Interop.Excel.Application()

is Executed I see EXCEL.EXE on task manager with the corresponding user
name ,NETWORK SERVICE and then fail to proceed with the error message given
above


samsonk

Microsoft.Office.Interop.Excel myexcel = new EXCEL.Application
 



Thanks Very much for your replay!
What Do you mean by "reference set to the object model" ? the code workers
perfect in my local!
the problem is in the server

"Patrick Molloy" wrote:

you have a reference set to the object model?



Chip Pearson

Microsoft.Office.Interop.Excel myexcel = new EXCEL.Application()
 

I don't know why you would get that error, but

&H8001010a translates
The message filter indicated that the application is busy.

and

&H80070005 translates to
Access is denied.

The only thing that comes to mind, and it is a long shot, is that
you're building a single-instance application and you have some Excel
process running in the background.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



On Mon, 5 Oct 2009 06:29:02 -0700, samsonk
wrote:

Here is the error message again
Creating an instance of the COM component with CLSID
{00024500-0000-0000-C000-000000000046} from the IClassFactory failed due to
the following error: 8001010a
Thanks

"samsonk" wrote:

I keep getting the error message when trying to execute

Microsoft.Office.Interop.Excel.Application myexcel = new
Microsoft.Office.Interop.Excel.Application()

In the bigining the error message was

Retrieving the COM class factory for component with CLSID
{00024500-0000-0000-C000-000000000046} failed due to the following error:
80070005.


But after reading and implementing some blogs suggestions like
http://blog.crowe.co.nz/archive/2006/03/02/589.aspx

The error changed to

Creating an instance of the COM component with CLSID
{00024500-0000-0000-C000-000000000046} from the IClassFactory failed due to
the following error: 8001010a

The application works perfect on my local the problem is on the hosting
server, windows 2003 server ( I have tried to give all the permission to
Network service administrator in DCOMCNFG and excel is installed on the
server too) but I keep on getting this error , from what I noticed every time
this line (Microsoft.Office.Interop.Excel.Application myexcel = new
Microsoft.Office.Interop.Excel.Application()

is Executed I see EXCEL.EXE on task manager with the corresponding user
name ,NETWORK SERVICE and then fail to proceed with the error message given
above


Samson

Microsoft.Office.Interop.Excel myexcel = new EXCEL.Application()
 

Thanks for your replay

I agree that the error is saying excel is busy ..But the Question is
why it is busy?, and how can i know what is running in the back
ground?. the thing is in my development computer the application works
perfect. i am thinking it is an issue of some kind of configuration in
server (office excel or firewall or antivirus softwares) a
please any suggestion is appreciated

Thanks you

[email protected]

Microsoft.Office.Interop.Excel myexcel = new EXCEL.Application()
 
VÃ*o 20:22:02 UTC+7 Thứ hai, ngÃ*y 05 tháng mÆ°á»i năm 2009, samsonk đã viết:
I keep getting the error message when trying to execute

Microsoft.Office.Interop.Excel.Application myexcel = new
Microsoft.Office.Interop.Excel.Application()

In the bigining the error message was

Retrieving the COM class factory for component with CLSID
{00024500-0000-0000-C000-000000000046} failed due to the following error:
80070005.


But after reading and implementing some blogs suggestions like
http://blog.crowe.co.nz/archive/2006/03/02/589.aspx

The error changed to

Creating an instance of the COM component with CLSID
{00024500-0000-0000-C000-000000000046} from the IClassFactory failed due to
the following error: 8001010a

The application works perfect on my local the problem is on the hosting
server, windows 2003 server ( I have tried to give all the permission to
Network service administrator in DCOMCNFG and excel is installed on the
server too) but I keep on getting this error , from what I noticed every time
this line (Microsoft.Office.Interop.Excel.Application myexcel = new
Microsoft.Office.Interop.Excel.Application()

is Executed I see EXCEL.EXE on task manager with the corresponding user
name ,NETWORK SERVICE and then fail to proceed with the error message given
above




All times are GMT +1. The time now is 07:17 PM.

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