An Example of Early Binding : Binding « Excel « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Excel
  3. Binding

An Example of Early Binding

 
Sub EarlyBinding()
    Dim objExcel As Excel.Application
    Set objExcel = New Excel.Application
    With objExcel
        .Visible = True
        .Workbooks.Add
        .Range("A1") = "Hello World"
    End With
End Sub








Related examples in the same category

1.Using the CreateObject Function to Create a Late-Bound Instance of Excel
2.Late Binding
3.Early vs. Late Binding
4.After the reference is set, Word variables can be declared with the correct (Word) variable type.
5.creates a new instance of Word and then opens and makes visible an existing Word document:
6.Creating and Referencing Objects
7.If multiple versions of Word are installed, you can create an object for a specific version. The following statement, for example, uses Word 97.