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
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