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

Difference between Tabletype and Snapshot?

0 Answers  

---

___,_____ and ____ container objects.

0 Answers  

---

How do you zoom in visual basic?

0 Answers  

---

Does VB support pointers to functions?

0 Answers  

---

Explain OLE Drag and Drop.

0 Answers  

---

How much gain in performance will I get if I write my number crunching routines in C instead of Visual Basic?

0 Answers  

---

What is meant by Establish Connection in RDO? 74.1s it possible to Access BackEnd procedures? Explain.

0 Answers  

---

How to get freefile location in memory?

0 Answers   FSS,

---

What is "Reserved Error -1209"?

0 Answers  

---

What is a thread pool and how are the threads within a thread pool managed?

0 Answers  

---

what is a property to resize a label control according to your caption?

2 Answers  

---

Is Visual Basic case sensitive in general?

3 Answers  

---