Answer / raghunath paul

after selecting Microsoft excel library in refrence
section we can create object for excel by CreateObject
("Excel.Application")

Answer / sugnaya

place two textbox and commandbuttons in design window
and copy this code in code window
-----------------------
Dim xl As New Excel.Application
Dim xlsheet As Excel.Worksheet
Dim xlwbook As New Excel.Workbook

Private Sub Command1_Click()
Text1.Text = xlsheet.Cells(2, 1)
Text2.Text = xlsheet.Cells(2, 2)
End Sub

Private Sub Command2_Click()
xlsheet.Cells(21, 1) = Text1.Text
xlsheet.Cells(21, 2) = Text2.Text
xlwbook.Save
End Sub

Private Sub Form_Load()
Set xlwbook = xl.Workbooks.Open("C:\Documents and
Settings\bct20vb\My Documents\sa.xls")
Set xlsheet = xlwbook.Sheets.Item(1)
End Sub

Answer / anjani

For Using Excel in Vb,we have to add reference of Microsoft
Excel libery. After That we can create object for excel and
we can able to use Excel in vb

Hai! , i make a project for browsing center using vb6.0 , at the time of running below mentioned error is occured so please help me for solve this problem. Error : Can't find project or library

4 Answers   Wipro,

---

Name some date functions?

1 Answers  

---

What is binding? What are types of binding?

3 Answers   Primus Global,

---

What are the rules which should be followed while naming a variable in VB?

0 Answers  

---

What is OLE and DDE? Explain?

1 Answers  

---

What is the use of ActiveX Documents?

0 Answers  

---

How do I implement an incremental search in list/dir/combo/file boxes?

0 Answers  

---

What is RdExecDirect?

1 Answers  

---

What do you mean by Databound Controls Explain?

0 Answers  

---

How would you map properties to controls by using ActiveX Control Interface Wizard?

0 Answers  

---

How do I call a DLL?

0 Answers  

---

Explain Get, Let, Set Properties.

1 Answers  

---