Answer Posted / 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

How would you create Visual basic Document file?

2632

---

Data Control missing from toolbox when I use VB under NT3.5. Why?

1475

---

Explain about ADO control?

1014

---

What is rdo in vb?

1311

---

What is the need of tabindex property is label control.

2001

---

Maximum Control Names length?

2395

---

To validate a range of values for a property whenever the property values changes,which type of property procedure you use?

1840

---

What is DBSqlPassThrough?

3245

---

Difference between ActiveX Control and Standard Control.

2625

---

Can you tell me the properties of the controls?

2045

---

How would you attach pictures in column headers of List View Control?

2098

---

What is data control in vb?

1018

---

Difference between DDE and OLE.

3315

---

What is snapshot in vb?

954

---

Which type of object requires this object?

1981

---