_Excel_RangeRead need help

[232showtime]

how can I _Excel_RangeRead in an existing and active worksheet?, which is already open. because in this example its working fine but it needs to open the worksheet first

#include <Array.au3>
#include <Excel.au3>
#include <MsgBoxConstants.au3>

; Create application object and open an example workbook
Local $oAppl = _Excel_Open()
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeRead Example", "Error creating the Excel application object." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
Local $oWorkbook = _Excel_BookOpen($oAppl, @ScriptDir & "\Extras\_Excel1.xls")
If @error Then
    MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeRead Example", "Error opening workbook '" & @ScriptDir & "\Extras\_Excel1.xls'." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
    _Excel_Close($oAppl)
    Exit
EndIf

; *****************************************************************************
; Read data from a single cell on the active sheet of the specified workbook
; *****************************************************************************
Local $sResult = _Excel_RangeRead($oWorkbook, Default, "A1")
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeRead Example 1", "Error reading from workbook." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeRead Example 1", "Data successfully read." & @CRLF & "Value of cell A1: " & $sResult)

Edited October 2, 2014 by 232showtime

[Bert]

_Excel_BookAttach

[232showtime]

Darth, I tried the other solution its working but its giving me a value of zero in notepad instead of AB

#include <Array.au3>
#include <Excel.au3>
WinActivate("[CLASS:XLMAIN]")
Local $oWorkbook = Winactive("[CLASS:XLMAIN]")
Local $sResult = _Excel_RangeRead($oWorkbook, Default, "I14")
ControlSetText("Untitled - Notepad", "", "[CLASS:Edit; INSTANCE:1]",$sResult)

whats wrong???

water need help... :sweating:

Edited October 2, 2014 by 232showtime

[water]

WinActivate returns the handle to the window.

_Excel_RangeRead needs the workbook object - which is something completele different.

You need to use _Excel_BookNew, _Excel_BookOpen or _Excel_BookAttach to get a workbook object.

[232showtime]

ok ill try it sensei... :rambo: