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

Why we need a MDI form? How can we make a form as a mdichild form?

2 Answers   TCS,

---

What is keyword used to compare two objects?

2 Answers  

---

what are the Control Categories?

1 Answers  

---

What are the uses of List View Control?

0 Answers  

---

what is the Difference between Query unload and unload in form?

1 Answers  

---

what are the types of LockEdits in DAO?

0 Answers  

---

What is ODBC?

2 Answers   Satyam,

---

How to use advanced data-bound controls.

0 Answers  

---

How can you Implement windows functionality in VB?

0 Answers  

---

How can you read content from file?

2 Answers  

---

___ VB constant make the menu item in centre.

0 Answers  

---

What's the difference between MODAL and MODELESS forms?

0 Answers  

---