How to extract data in invisible rows in acxTable?

[paul_20k]

Hi

I have an acxTable within windows application. It has 100 rows and 20 columns. Only 11 rows are visble on the screen. When I use rowcount/columncount method it shows correct values for number of rows and number of colmuns. When I try to extract data from some cells, it works perfectly until row 11 and as soon as it touches row 12 and onwards, it shows error message "Type Mismatch" and in msgbox it shows contents of the cell as "Object Reference" and stops.

I tried all methods available for activex tables like MakeCellVisible, makevisible etc but nothing worked. I tried sendkeys so that rows after 11 shows up on the screen but it stops even data is showing on the screen. Is there any way to extract data from all cells within acxTable?

Ankur...as you already worked with ActiveX controls, maybe you can give me some hint to dig deep into this issue.

Thanks

[Ankur]

Are the next 89 rows coming up on subsequent pages or they are not showing up at all?

[paul_20k]

Hi Ankur

Thanks for you quick reply. All 89 rows are in the same page but hidden with scrollbar. So I can see them if I scroll down. Even I can make rows visible with sendkeys, it still gives me the same errors as described in previous post.

Thanks

[Ankur]

In that case, I am sure there should be a 'method' available for it...just object spy on it.

Can you attach 'object spy' image here?

[paul_20k]

I don't have access to the application right now as its weekend but I will send you object spy screenshot on monday. I tried all methods available but nothing worked.

[paul_20k]

Hi Ankur

I am attaching "object spy" image. Please help in finding solution to the above issue.

Thanks