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

What is meant by building a recordset.

0 Answers  

---

Whether HTML supports multimedia: and document links?

0 Answers  

---

What is the max size of textbox?

1 Answers  

---

What is view Port?

1 Answers  

---

What is the use of Visual Basic Document file?

0 Answers  

---

How do I play MID, WAV or other multimedia files?

0 Answers  

---

How many MDI(multiple document interface) forms can include in one project(especially in visual basic)?

6 Answers   Satyam, VSS,

---

How to register a component?

1 Answers  

---

What do you mean by ADO?

1 Answers  

---

What is meant by Establish Connection in RDO?

0 Answers  

---

Under which circumstance does a VB application ignore a Timer event?

2 Answers  

---

How to find size of the file. Which method or function is used to occomplish this?

1 Answers  

---