[RESOLVED] VB6 & Excel newbie question

[RobDog888]

Ok, Early Binding vs. Late Binding...

'Early Binding
'Add a reference to MS Excel xx.0 Object Library
Private moApp As Excel.Application
 
'Late Binding
'No reference added to Excel at all
Private moApp As Object

Early binding locks in your reference to that version of Excel. Late binding does not. It only binds to the version that is available on the system.

With Early binding you get the intellisense popups showing the functions, methods, and properties of your object variable. Late binding does not support any intellisense since it doesnt know what it is until runtime.