While importing Excel in visual studio 2005 Error throws in VISTA Creating an instance of the COM component with CLSID {00020820-0000-0000-C000-000000000046} from the IClassFactory failed due to...

See more:

C#

VB

Iam importing Excel in visual studio 2005
Imports Microsoft.Office.Interop.Excel

I have create Instance Like this

Dim excel As New Microsoft.Office.Interop.Excel.Application
Dim wBook As Microsoft.Office.Interop.Excel.Workbook
Dim wSheet As New Microsoft.Office.Interop.Excel.Worksheet
wBook = excel.Workbooks.Add()

and used Range Method to calucalte as follows:-

'wSheet.Range(A1).Value.ToString'


The Following error occured it's working fine in XP
but it's not working in VISTA

Creating an instance of the COM component with CLSID {00020820-0000-0000-C000-000000000046} from the IClassFactory failed due to the following error: 80010001.

Iam Using Microsoft.Excel 12.0 object Library.


Pls give me a solution
Regards
Pratheesh