Welcome to EDAboard.com

Welcome to our site! EDAboard.com is an international Electronics Discussion Forum focused on EDA software, circuits, schematics, books, theory, papers, asic, pld, 8051, DSP, Network, RF, Analog Design, PCB, Service Manuals... and a whole lot more! To participate you need to register. Registration is free. Click here to register now.

problem with vb excel linking

Status
Not open for further replies.

yviswanathbe

Full Member level 4
Joined
Jun 14, 2007
Messages
221
Helped
10
Reputation
20
Reaction score
6
Trophy points
1,298
Activity points
3,065
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

Full Member level 4
Joined
Feb 21, 2006
Messages
199
Helped
17
Reputation
34
Reaction score
3
Trophy points
1,298
Activity points
2,902
Did you add a reference to excel in your vb project?
 

yviswanathbe

Full Member level 4
Joined
Jun 14, 2007
Messages
221
Helped
10
Reputation
20
Reaction score
6
Trophy points
1,298
Activity points
3,065
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

Full Member level 4
Joined
Feb 21, 2006
Messages
199
Helped
17
Reputation
34
Reaction score
3
Trophy points
1,298
Activity points
2,902
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

Full Member level 4
Joined
Jun 14, 2007
Messages
221
Helped
10
Reputation
20
Reaction score
6
Trophy points
1,298
Activity points
3,065
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.
 

Status
Not open for further replies.

Part and Inventory Search

Welcome to EDABoard.com

Sponsor

Top