To create an Excel instance code using CreateObject

First, use CreateObject to create Excel

Sub latebinding ()

' Declare a Generic object variable

Dim Objexcel as Object

' Point the ' object variable in an Excel Application object

Set Objexcel = CreateObject ("Excel.Application")

' Set properties and Execute methods of the object

With Objexcel

. Visible = True

. Workbooks.Add

. Range ("A1") = "Hello World"

End With

End Sub

Use CreateObject to create a specific version of Excel instance

Sub Mate ()

Dim Objexcel as Object

Set Objexcel = CreateObject ("Excel.application.8")

End Sub

After the Create object instance, you can use all the properties and methods of the object, such as the SaveAs method, the open method, the Application property, and so on.