Introduction
Excel Application
Control Flow - Statements
Wkb Add-in Attendance
Forms with Excel

 

 

 

 

 

    Object Hierarchy

  • It is Object based language

    •  

  • These objects has to define in sequential Order

    •  

     

    Assembly

     

  • One or more set of Modules is termed as ASSEMBLY, utilized to construct the application

    •  

     

    Add LIBRARY reference

     

     

    Add Image icon to the button in the RIBBON

     

     

    StartUp Event

     

     

    Nullyfing the variables

     

  • XLApp.Quit
  • Set XLApp = Nothing
  • Set XLWkb = Nothing
  • Set XLSh = Nothing

    •  

     

    VBA Vs VB.net

     

     

    Define Excel Application

    VBA

  • No need to define\import Excel as we are writing the code in excel itself

    • VB.Net

  • We need to define the Excel Application

    •  

     

    Define Variable to the Inputbox

    VBA

     

     

    Add New Workbook

     

     

    Define worksheet

     

     

     

     

    Define LastRow

     

     

    Define LastColumn

     

     

    Copy - Paste

     

     

    Add sheets at the end of sheets count

     

     

     

    Horizontal Alignment

     

     

    Range Method and cells Property

     

     

    Worksheet Functions

     

Welcome to VB.Net Tutorial