Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> .NET Development >> .NET Base Class Library

Additional information: COM object with CLSID {00020819-0000-0000-C000-000000000046} is either n

I am using excell 2000 and vb.net when i am opening a workboob using vb.net then this problem comes -Additional information: COM object with CLSID {00020819-0000-0000-C000-000000000046} is either not valid or not registered.
pls tell me solutions as soon as possible
with regards
thanksIdeaIdea
[442 byte] By [sunarc] at [2007-12-16]
«« How can a MDI child form set the StatusBar's property which host on the MDI parent?
»» Middle Tier and Whidbey
# 1
It sounds like the excel 2000 component is not registered?

You can open the registry "regedit.exe"

Look for the registry HKEY_CLASSROOT\CLSID\{00020819-0000-0000-C000-000000000046} to see if the info there is correct.
Usually the info should contain the there should be a path to the excell dll under InProcServer2000

Yiru at 2007-9-9 > top of Msdn Tech,.NET Development,.NET Base Class Library...
# 2
I have the same problem with excel 2003, the default value for InProcServer32 is not set. How can I get the path to these interops?
PaulScheremet at 2007-9-9 > top of Msdn Tech,.NET Development,.NET Base Class Library...
# 3
iam getting this "

COM object with CLSID {00020819-0000-0000-C000-000000000046} is either not valid or not registered.

"

Type Of eeror Iam Using office 2003 How Can I come out With this error

Forum: .NET Base Class Library
Posted: : Monday, November 7, 2005 11:57 AM
Post Subject: : Re: Additional information: COM object with CLSID {00020819-0000-0000-C000-000000000046} is either not valid or not registered.

Paul Scheremet wrote:
I have the same problem with excel 2003, the default value for InProcServer32 is not set. How can I get the path to these interops?
Yakub at 2007-9-9 > top of Msdn Tech,.NET Development,.NET Base Class Library...
# 4

Hi,

The actual problem is in your code U might be using this piece of code

Dim TestExcelWb As New Excel.Workbook

actually this is not supported . So u get that kind of Error.

There is somthing Excel.Application in .Net . Create an Object of it and add the workbook to it. then Code goes like this

Public oApp As New Excel.Application

Dim TestExcelWb As Excel.Workbook

TestExcelWb = oApp.Workbooks.Open("D:\Manesh.xls")

TestExcelWb.Application.Visible = True

Now it should work fine.

Hope this will Help U

Regards,

Manesh

Manesh_myworld at 2007-9-9 > top of Msdn Tech,.NET Development,.NET Base Class Library...
# 5
Hi

I am using the similar code as u have given, but when it executes the following line,

TestExcelWb = oApp.Workbooks.Open("D:\myfile.xls")

the exception message is

"Object reference not set to an instance of an object"

When I checkd it, TestExcelWb prior to execution of this line is "nothing".

any suggestion will be appreciated.

Regards

CoolDeep at 2007-9-9 > top of Msdn Tech,.NET Development,.NET Base Class Library...
.NET Development
.NET Base Class Library

.NET Development Hot Topic

.NET Development New Topic

.NET Development

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified