crystal reports XI and VBA

Hi folks..
I am using crystal reports created in version XI with Excel(VBA).
i have the following code to display the report..
********************
Private Sub CommandButton2_Click()
Dim rep As New CrystalReport
rep.ReportFileName = "c:\apcg\test\report1.rpt"

CRViewer1.ReportSource = rep
CRViewer1.ViewReport
End Sub

************
But i am facing an error
Runtime error:430 - Class does not support Automation or does not support expected interface..

Could you any one solve this problem..

i knew that the problem is with CRViewer.dll
when i tried to register that file, it failed..
also i am getting an error "Error accessing Registry" when i click references in VB project menu...

Thanks in advance
salaiTry to reinstall CR X1 and see what happens

Crystal Report XI with Excel(VBA).

Hi folks..
I am using crystal reports created in version XI with Excel(VBA).
i have the following code to display the report..
********************
Private Sub CommandButton2_Click()
Dim rep As New CrystalReport
rep.ReportFileName = "c:\apcg\test\report1.rpt"

CRViewer1.ReportSource = rep
CRViewer1.ViewReport
End Sub

************
But i am facing an error
Runtime error:430 - Class does not support Automation or does not support expected interface..

Could you any one solve this problem..

i knew that the problem is with CRViewer.dll
when i tried to register that file, it failed..
also i am getting an error "Error accessing Registry" when i click references in VB project menu...

Thanks in advance
salaiTry to reinstall CR and see what happens