How do we call MS- Excel in VB?
Answers were Sorted based on User's Feedback
Answer / raghunath paul
after selecting Microsoft excel library in refrence
section we can create object for excel by CreateObject
("Excel.Application")
Is This Answer Correct ? | 7 Yes | 0 No |
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
Is This Answer Correct ? | 8 Yes | 1 No |
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
Is This Answer Correct ? | 2 Yes | 0 No |
What is DBFailError?
What is the use of Scalewidth and ScaleHeight Proeperty?
how to make unlimited id(1rimjim,2rimjim,3rimjim....etc) login grp chat pogram for jabber?
DHTML Is used for what?
Is it possible to call oracle database through ADO control or Object?
Draw Sequence Modal of DAO and Explain?
I want to develop a stand alone application which can communicate with the existing applications in the system. On which this application should be based on: Standard Exe, Active-X Exe, Active-X Dll.
What is ActiveX? Explain.
What is the need of zorder method?
Why API functions are Required?
by writing MACRO CODE,i want to retrive data from one spead sheet to another UI (workbook). control will search cell by cell for each row and load the data in another workbook(UI). ex: custdetails custname lastname locaton mobile pincode custdetails raj tony hyd 555555 521245 servcreqrd srvce# srvcename location srvcepincode servcreqrd 754 drilling hyd 521784 for the above example in the another workbook retrive data like this custname Raj srvce# 754 srvcepincode 521784. while retrieving data control will search cell by cell for each row.
What is difference between procedural prog. Language