upobDaPlaya
asked on
Binding - MS Access to MS Excel - What is it and does it matter
I have read a few posts where people have indicated when within MS Access and creating an Excel instance that typically binding does not matter. I am not quite sure what binding is relative to MS Access/Excel even after reading the posts.
However, one person indicated you should not do this:
Dim xlobj as Excel.Application
Dim objxlbook as workbook
Dim objxlsheet as worksheet
Set xlobj = CreateObject("Excel.Applic ation)
You should do this
Dim xlobj as Object
Dim objxlbook as Object
Dim objxlsheet as Objects
Set xlobj = CreateObject("Excel.Applic ation)
Whats the difference between the 2 sets of code ?
However, one person indicated you should not do this:
Dim xlobj as Excel.Application
Dim objxlbook as workbook
Dim objxlsheet as worksheet
Set xlobj = CreateObject("Excel.Applic
You should do this
Dim xlobj as Object
Dim objxlbook as Object
Dim objxlsheet as Objects
Set xlobj = CreateObject("Excel.Applic
Whats the difference between the 2 sets of code ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Good explanation Nick
ASKER
Great. It makes sense for me to go with early binding.