G
Greg
error 2029 is an excel error.
At work I am developing a VB6 app that works with Excel 2002 (ok, they are
old versions, but that is a corporate decision).
When I instantiate an excel object and read certain cells the value is
returned, but with other cells I get "error 2029". I paste from the
immediate window:
?owb.Worksheets("minResults").Range("J4")
6466.4725133961
6466.4725133961
?owb.Worksheets("minResults").Range("J5")
Error 2029
Error 2029
The instantiation of excel objects is fine, peers have reviewed it, but this
error is replicated on different a page (eg the worksheets("maxresults")
cells J4 and J5 show the same pattern.
I have changed my program so that all I do is early bind to excel and then
attempt to read these cells, cutting away any other possible factors.
Any ideas anybody ?
At work I am developing a VB6 app that works with Excel 2002 (ok, they are
old versions, but that is a corporate decision).
When I instantiate an excel object and read certain cells the value is
returned, but with other cells I get "error 2029". I paste from the
immediate window:
?owb.Worksheets("minResults").Range("J4")
6466.4725133961
6466.4725133961
?owb.Worksheets("minResults").Range("J5")
Error 2029
Error 2029
The instantiation of excel objects is fine, peers have reviewed it, but this
error is replicated on different a page (eg the worksheets("maxresults")
cells J4 and J5 show the same pattern.
I have changed my program so that all I do is early bind to excel and then
attempt to read these cells, cutting away any other possible factors.
Any ideas anybody ?