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

How would you run your ActiveX Document Dll?

0 Answers  

---

____ property of menu cannot be set at run time.

0 Answers  

---

How do I implement Undo?

0 Answers  

---

What is the different between Microsoft ODBC Driver and Oracle OBDC Driver?

1 Answers  

---

Which Property is used to compress a image in image control?

1 Answers  

---

Explain the usage of Web Browser Control?

0 Answers  

---

What is the difference between modal and modaless form in VB?

1 Answers  

---

How would you attach an ActiveX control in Your Application?

0 Answers  

---

How can I change the printer Windows uses in code without using the print common dialog? How can I change orientation?

0 Answers  

---

What is controls in vb?

0 Answers  

---

What is dao in visual basic?

0 Answers  

---

What is DDE?

1 Answers  

---