>There is also an older article in MSDN on vfp, performance and COM showing that if each object has to be discovered across COM [loCOM.Tables[1].Sheet[1].Cell[i, j] or something similar from excel] in a single line this can put a serious damper on performance. I think the article was still vfp6 based and put only forward as tip the hint to set a object reference "down the line" of the COM object.
>
>Instead of
>for lnRun = 1 To
> lctext = loCOM.Tables[1].Sheet[1].Cell[i, lnRun]
>endfor
>
>
>use
>
>
>loObj = loCOM.Tables[1].Sheet[1]
>for lnRun = 1 To
> lctext = loObj.Cell[i, lnRun]
>endfor
>How the "for each" works in this aspect (you have to "get" the object FROM COM as well: DUNNO <g>.
>Here I'ld try walking explicitly [via index] across the lowest, already early bound COM object reference.
The code I am using is already using the lowest COM object reference. I also have to fix first the problem as to know why this is running extremely slow on this PC as oppose to others who tested it.