C
Carl
Hello,
I have some VB6 code in an ActiveX dll running inside a VSL wrapper. This
code goes through a loop, calling a function that drops a master on the page
in each loop. After dropping the master the function updates the text in one
cell while another cell recalculates the shape height using the TEXTHEIGHT()
function. My function then returns a reference to the new shape to the main
loop. I use that shape reference to read the .Cells("Height") to do further
processing.
Unfortunately, the height value returned is the height of the shape when it
was initially dropped on the page, not the recalculated height. I can see
the height has changed by looking at the shape on the page, but the height
returned to my code doesn't get updated. I've tried different thngs such as
the cell.trigger to try force a recalc with no luck. The shape appears not
to trigger a recalc until I exit the loop. I've tried looking at the
CellChanged event and even have tried to release the shape reference and get
a new one but it still won't return the new height. It seems to que up the
events until the loop is finished even with a DoEvents in the loop.
Is there any way to do this?
Thanks, Carl
I have some VB6 code in an ActiveX dll running inside a VSL wrapper. This
code goes through a loop, calling a function that drops a master on the page
in each loop. After dropping the master the function updates the text in one
cell while another cell recalculates the shape height using the TEXTHEIGHT()
function. My function then returns a reference to the new shape to the main
loop. I use that shape reference to read the .Cells("Height") to do further
processing.
Unfortunately, the height value returned is the height of the shape when it
was initially dropped on the page, not the recalculated height. I can see
the height has changed by looking at the shape on the page, but the height
returned to my code doesn't get updated. I've tried different thngs such as
the cell.trigger to try force a recalc with no luck. The shape appears not
to trigger a recalc until I exit the loop. I've tried looking at the
CellChanged event and even have tried to release the shape reference and get
a new one but it still won't return the new height. It seems to que up the
events until the loop is finished even with a DoEvents in the loop.
Is there any way to do this?
Thanks, Carl