Solved: Only running MyExcel.xls on named machine?

[Simon Lloyd]

Hi....again!, ive just been reading about QI queryinterface and the pro's and cons of calling it Early Bound or Late Bound, where it explains that if we use Early binding we pass the object to the compiler first where excel is able to work out all the pointers from the class module first and so speeding things up a little and late bound seems to be the opposite, i know you haven't specified any binding properties so im confident that we dont need them, i was just thinking of the scenario of when my workbook is around 5meg and my database in excess of 2000 entries what the amount of time would be for the code execution and whether specifying Early binding would make a difference, or am i barking up the wrong tree?

 
' LATE binding 
Dim XLObj As Object 
Set XLObj = CreateObject("Excel.Application") 
' same thing with GetObject instead of CreateObject 
' EARLY binding 
Dim XLObj As Excel.Application 
Set XLObj = New Excel.Application

regards,
Simon
P.S this thread is becoming monsterous! lol