problem with vb excel linking

[yviswanathbe]

Hi friends,
I am doing an ATE for my UUT(Unit Under Test) using vb6.0
In this i am measuring frequency,power,vswr etc automatically and storing in MS Acess database.
Now i want to store the values in excel.
i am an error when i am opening the excel application from vb.
error is:
Automation Error
Library not registered

please help how to solve this issue
Thanks in advance

 

[jhbbunch]

Did you add a reference to excel in your vb project?

 

[yviswanathbe]

yes.
this is how i did the coding

1)Dim myexcel As Excel.Application
2)Dim book As Excel.Workbook
3)Dim sheet As Excel.Worksheet
4)Dim range As Excel.range
5)Dim data_SNo, Row As Integer
6)Set myexcel = CreateObject("Excel.Application")
7)myexcel.Visible = True
8)Set book = myexcel.Workbooks.Add
9)Set sheet = book.ActiveSheet

i am getting the error at 6th line...
1 week before the above code was working fine.
suddenly wat happen i dont know am getting errors.

 

[jhbbunch]

The code runs fine for me. By adding a reference I hope you mean that you go to Progject->References and select the Excel Object Library. Also, is Excel properly installed on your computer? Is the pathname correct? That is about all I can think of?

 

[yviswanathbe]

for this statement
"Set myexcel1 = CreateObject("Excel.Application")"
after the dot after excel application should come automatically,but in my project it is not .so might be the problem with installation?

actually i have 2 versions of MS ofiice were installed,i have removed one of the version,from that time i am not able to access the excel from the VB.

Please give some suggesion,Thanks for ur help.