_Excel_RangeRead help

[232showtime]

how to read single active cell, like for example

;; i will click on B33 or I will move the selection from B40 to B33 using arrow keys then do my script

$ClickedCell = ""

HotKeySet("{F1}", "Read")

Func Read()

Local $sText = WinGetTitle("[CLASS:XLMAIN]")
$iText = StringLeft($sText, 5)
Local $sWorkbook = $iText & ".xlsx"
$oWorkbook = _Excel_BookAttach($sWorkbook, "filename")
Local $sResult = _Excel_RangeRead($oWorkbook, Default, $ClickedCell)
MsgBox(0, "Excel", $sResult)


EndFunc

how will i get the data from $ClickedCell ??? except for ctrl+v

Edited April 9, 2015 by 232showtime

[water]

I do not see _Excel_Open in your code.

To get the active cell you would use $oExcel.ActiveCell. $oExcel is the application object as returned by _Excel_Open.

[232showtime]

book1.xlsx is already open and i used book attach to get application obj. could you give me example about $oExcel.ActiveCell its kinda new to me dont know where to start.. pleaaaaaasssseeee o:)

[water]

$oExcel.ActiveCell gives you the active cell of the active sheet in the active workbook.

Means: The cell the user selected by clicking on it.

[232showtime]

got it... found and modified some examples here in forum but how to remove the $ sign???

Global $CellNo

HotKeySet("{F1}", "Read")
$oExcel = ObjGet("", "Excel.Application")

While 1
    Sleep(100)
WEnd

Func Read()

    $active = $oExcel.ActiveCell.Address
    If $CellNo <> $active Then
        $CellNo = $active
        MsgBox(0, "Success", "Range is : " & $active )
    EndIf

EndFunc   ;==>Read

Edited April 12, 2015 by 232showtime

[water]

Which $ sign?

[232showtime]

if you run my script message box will pop out and will say, Range is : $A$232....  $ sign in message box output...

I want to get only the text, like, Range is : A232

Edited April 12, 2015 by 232showtime

[water]

That's an absolute cell reference.

Please have a look at function _Excel_ConvertFormula to convert it to a relative reference.