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

what is the Difference between Tabletype and Snapshot?

2086

---

What is the use of Immediate, Local Window?

2040

---

___ Property is used to count no. of items in a combobox.

1390

---

Which method is used to write context Into file?

2044

---

What is Seek Method which type of record set is available this?

1911

---

What is the use of Data Form Wizard?

1975

---

What is script control?

1054

---

What are the tools in visual basic?

1061

---

What is vbs file?

1000

---

Are there any examples of commercial applications built using Visual Basic?

1730

---

What do you know about user forms.

1098

---

Difference between Dynaset and Snapshot?

2116

---

how to use telugu language in vb6? any unicode data is available for telugu or not?yes means how to use? my desired output is telugu only? i am doing project like(telugu calendar),my output should be print in telugu only? pls send me the solution with code?

3547

---

___,___ and __ are difference between image and picture controls.

1558

---

What is difference between datagrid and flexgrid?

13975

---