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 do I make the mouse cursor invisible/visible?

0 Answers  

---

Explain the types of Views in Listview Control.

0 Answers  

---

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

2 Answers  

---

Why we use Treeview Control?

2 Answers  

---

What is visual basic used for?

0 Answers  

---

Record set types and Number available in Visual Basic?

1 Answers  

---

How do you do multithreading application in VB

1 Answers  

---

Where can I get good up-to-date information about VB?

0 Answers  

---

what are Collections?

1 Answers  

---

How to find the current record position in data control?

2 Answers  

---

What is the use of progress Bar Control?

0 Answers  

---

Hi, I am USINg QTP tool for automation. Where VB Script have to use. I want to read a row from the table present in .Doc File and to paste in excel. Could you please assist me or give me the code to get it. I am new in this technology.

0 Answers   Accenture,

---