What is early binding and late binding

[BizBoy]

Hi
I am new to these concepts.
Not requesting for exact answers.
You may also help me with useful links for these two.

I know Google will help, but trying to seek help from experts here.
Also, I have another question here.
Not sure if I can merge it here only.

How does early binding or late binding affects compatibility when moving from older access version to Office 365.
Please pardon my ignorance, I am novice to access and need to work on these issues.

 

[BizBoy]

Hi,
Can anyone please review below code and guide me if possible.
I have copied early binding instance from the code and tried to convert it to late binding.

Could you please confirm if am doing it correct way. Thanks.

Public X__App As Excel.Application
Public x__Wb As Workbook
Public x__ws As Worksheet

Sub Test()
'Ealry binding
Set X__App =CreateObject("Excel.Application")
Set x__Wb = X__App.Workbooks.Open(XX__PATH &"Test\Test.xlsb", False, True)

'Late Binding
Dim X__App As Object
Dim x__Wb As Object
Dim x__Wb As Object

Set X__App =CreateObject("Excel.application")
Set x__Wb = X__App.Workbooks.Open(XX__PATH &"Test\Test.xlsb", False, True)
Set x__ws = x__Wb.Worksheets("Test")
End Sub

 

[RoryA]

The late binding is correct but you would of course need to remove the early bound Public variables.

 

[BizBoy]

Hi RoryA sir, yes, you are correct. These were kept just as a reference to post.
Have a nice day ahead.

 

[BizBoy]

Hi Experts,

I have a question. If I change a code from Early Binding to Late Binding, will there be any difference in the output.
If all the input parameters are same, will early or late binding affect the output in any way.

My guess is, it should not, however I am not sure, hence seeking help.
Can anyone please help me in this.

 

[RoryA]

No, there should be no difference.

 

[BizBoy]

Thanks a lot RoryA sir. Have a nice day ahead.