Excel Grid does not resize as it should the 1st time.

[ptrex]

@jpm

Your right never say last

Post #156 includes the solution for the 100% CPU.

For the LEFT MOUSE CLICK in the first CELL.

If I know how to sent a RIGHT MOUSE click than I can try to figure out how to do it.

Can you show how to sent a right mouse click, in a certain windows position, in AutoIT

Thanks

Edited November 17, 2005 by ptrex

[ptrex]

@jpm

Found a work around for the jumping of the Excel COM.

GUISetState(@SW_SHOW, $Main)
GUICtrlSetState($ExcelLV,$GUI_FOCUS)
MouseClick("Left")

Set the focus on the Object and clicks it when opening. Problem gone.

[kjactive]

Fine solution but if you do not want the window to have focus then this code should click at first node

$tmp = WinGetPos($MainWin)
    MouseClick("left", $tmp[0] + 80, $tmp[1] + 80,1,1)
GuiSetState()

kjactive

[ptrex]

@kjactive

Indead your solution is cleaner.

This clicks in the first cell.

GUISetState(@SW_SHOW, $Main)
$tmp = WinGetPos($GUIText)
    MouseClick("left", $tmp[0] + 275, $tmp[1] + 30,1,1); Clicks on the Object GUICtrlCreateObj($ExcelLV,265,1,730,415)

I have put it after teh GUISetSate command does it matter ?

Or should I put the GUISetState() afterwards as well ?

[kjactive]

No - just before GuiSetState makes no differense...

Hell - there is lots of functions to this activex component but I was looking for a function to make another cell active / change focus directly in the component but to much to look up and you did not stated your component PROGID or CLSID so I leave it here...

good luck

kjactive

[ptrex]

Thanks for the feedback !!

Probably see you around in one of the other threads ?!