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 the default property of data control?

2 Answers  

---

How many ways you can access file using VB?

0 Answers  

---

what is the Default property of datacontrol ?

2 Answers  

---

how a multiple routing works ?

0 Answers  

---

How can you Navigate from the DHTML application to another DHTML application? .

0 Answers  

---

What will happen if you issue a Resume statement after handling an error?

3 Answers  

---

What two methods are called from the ObjectContext object to inform MTS that the transaction was successful or unsuccessful?

1 Answers  

---

What is the difference between queryunload and unload in form?

2 Answers  

---

How can you Add API functions to your Application?

1 Answers  

---

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

0 Answers  

---

What is OLE and DDE? Explain?

1 Answers  

---

___ VB constant make the menu item in centre.

0 Answers  

---