ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Microsoft Related  >>  Visual Basic
 
 


 

 
 Visual Basic interview questions  Visual Basic Interview Questions
 C Sharp interview questions  C Sharp Interview Questions
 ASP.NET interview questions  ASP.NET Interview Questions
 VB.NET interview questions  VB.NET Interview Questions
 COM+ interview questions  COM+ Interview Questions
 ADO.NET interview questions  ADO.NET Interview Questions
 IIS interview questions  IIS Interview Questions
 MTS interview questions  MTS Interview Questions
 Crystal Reports interview questions  Crystal Reports Interview Questions
 BizTalk interview questions  BizTalk Interview Questions
 Dot Net interview questions  Dot Net Interview Questions
 Exchange Server interview questions  Exchange Server Interview Questions
 SharePoint interview questions  SharePoint Interview Questions
 Microsoft Related AllOther interview questions  Microsoft Related AllOther Interview Questions
Question
How do we call MS- Excel in VB?
 Question Submitted By :: Honeysukumar
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How do we call MS- Excel in VB?
Answer
# 1
after selecting Microsoft excel library in refrence 
section  we can create object for excel by CreateObject
("Excel.Application")
 
Is This Answer Correct ?    6 Yes 0 No
Raghunath Paul
 
  Re: How do we call MS- Excel in VB?
Answer
# 2
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 ?    7 Yes 1 No
Sugnaya
 
 
 
  Re: How do we call MS- Excel in VB?
Answer
# 3
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
Anjani
 

 
 
 
Other Visual Basic Interview Questions
 
  Question Asked @ Answers
 
What is Implicit?  1
what is the Default property of datacontrol ?  2
What is the use of Active Control Property?  1
How do we call MS- Excel in VB?  3
Is VB comes under Object Oriented Programming ?  1
What is binding? What are types of binding? Primus-Global3
What is the difference between Msgbox Statement and MsgboxQ function?  1
What does Addressof operator do?  1
What is a datacontrol?  1
What is the max size of textbox?  1
What is the difference between early binding and late binding?  1
what is visual basic  11
Clear property is available in hich control?  1
Different types of Passing Value?  1
What type of record sets are available in ADO?  4
what are Instancing for classes provided by ActiveX component like prive, publicnotcreatable,SingleUse, GlobalSinleUse,MultiUse. HCL1
What is the different between Microsoft ODBC Driver and Oracle OBDC Driver?  1
What are the types of validations available in Visual Basic? Infosys2
Write the correct order of execution of following form?s events: initialization, Load, Activate, Refresh , Paint  3
What are the Sequence of events when a form is loaded in Visual Basic?  5
 
For more Visual Basic Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com