Answer Posted / 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
Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Write the Steps in Creating an ActiveX Control?
What is meant by Establish Connection in RDO? 74.1s it possible to Access BackEnd procedures? Explain.
What is FireHouse Cursors?
what is the Difference between Dynaset and Snapshot?
What is instantiating?
what controls have you used in your project?
How do I speed up control property access?
How can you determine performance standards?
What is visual basic used for?
What are the types of line styles available in Treeview Control?
Is it posible to Create Tables Through Querydef?
How would you create properties in ActiveX Control?
Why does everybody say I should save in TEXT not BINARY?
Timer control contains ________ no. of events.
How can you filter out specific type of file using file system controls?