Help with ControlGetText from MSFlexGridWndClass

[STSRob]

I am having a problem trying to get ControlGetText to return text from Grids.

Here is Control Information of the Grid:

>>>> Control <<<<

Class: MSFlexGridWndClass

Instance: 1

ClassnameNN: MSFlexGridWndClass1

ID:

Text:

Position: 285, 366

Size: 480, 80

ControlClick Coords: 189, 46

Style: 0x54000000

ExStyle: 0x00000000

Handle: 0x00010184

--------------------------------------------------------------

Example Code:

----------------------------

$HEX = "0x00010184"

$text = ControlGetText ( "", "", HWnd($HEX) )

MsgBox(0, "Text read from Control Handle:" & HWnd($HEX) & " was:", $text)

----------------------------

In my real code I pass $HEX in as a parameter instead of hard coding it. When I use this approach it has worked for other controls I interact with, but no luck so far for this.

Any feedback wold be great.

Thanks

Rob

[zfisherdrums]

Hello STSRob,

MSFlexGridWndClass controls are somewhat notorious for not giving up the ghost when it comes to reading text.

Assuming you don't have the developer around to register custom messages, you may want to try to:

1 - Determine if you can activate a cell and copy its contents to the clipboard

2 - Determine if you can activate a cell and spy on it. Some grid controls ( like FarPoint Spread controls ) will expose the active cell

3 - Use OCR there are some OCR scripts floating around the forum. Then there's the MODI object ( included with MS Office 2003 ) or pay out $40 for SnagIt8.

One last trick: An application I was working with had a grid object that did not appear to respond to clipboard commands. So I wrote a quick script that placed the contents of the clipboard in the SciTe output console whenever it changed. With that script running in the background, I brought the application up and proceeded to try different combinations of keys. I eventually discovered a key sequence that placed a row of text in the clipboard ( in this case, Ctrl-F9 ). If you don't want to write a script, you can use the Office Clipboard.

Hope this helps,

Zach...

Edited December 15, 2007 by zfisherdrums